Re: last inserted raw (identity)

On Fri, 2003-08-01 at 18:25, b b wrote:
> Is there an environment variable that returns the
> primary key of the last inserted row. This is usefull
> if you insert a rwo and need the primary key to insert
> it into another table as a foreign key.
>
> In MS-SQL that is equivalent to @@identity variable:
> insert into organization ('org name', ....)
> insert into contact (@@identity, 'contact name'
> .....)
> Here Identity is the organization's ID that is needed
> as a foreign key in contact table.

Why "environment variable"? Are you writing this in shell?

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+