@@IDENTITY equivalent

[rxt]

Is there a @@IDENTITY equivalent (MS SQL Server 2000) in MySQL? :

 

[sleipnir214]

Dunno. What does @@IDENTITY do?

If it contains the last-generated auto-increment column number generated, the MySQL equivalent is the function last_insert_id() (

http://www.mysql.com/doc/en/Miscellaneous_functions.html)

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[vanekl]

It's not exactly like @@IDENTITY, but it's darn close:

LAST_INSERT_ID([expr])
Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column.
mysql> SELECT LAST_INSERT_ID();
-> 195

The last ID that was generated is maintained in the server on a per-connection basis.

 

[tshot]

then what does @@identity do which is not supported my mysql ?




----------------
ur feedback is a very welcome desire

 

[vanekl]

If you insert many rows at the same time with an insert statement, LAST_INSERT_ID() returns the value for the first inserted row. @@IDENTITY would return the last.

 

[rzs0502]

If you have multiple inserts in one statement, last_insert_id will show you the value of the first inserted row for that session. Else it will show you the last value inserted by that session.

@@IDENTITY is a synonym for last_insert_id in version 3.23.25.
Function is for Visual Basic compatibility

"If you always do what you've always done, you will always be where you've always been."