Getting ID of current record

[s4dadmin]

I have converted from Access to mysql. I am receiving an error with this sql statement which works fine in Access. I insert a record then I need to get the ID of that record.

SELECT @@IDENTITY;

Description=[TCX][MyODBC]You have an error in your SQL syntax near
'@IDENTITY' at line 1

What type of change do I need to make this work?

 

[sleipnir214]

That's because MySQL doesn't support any kind of @@variablename queries.

Try:

select last_insert_id()


This MySQL builtin function is documented here:

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!

 

[WizyWyg]

Read the site:

http://www.mysql.com/doc/en/ODBC_and_last_insert_id.html

 

[s4dadmin]

For some reason running select last_insert_id() runs perfectly on my host server, but on my personal computer under localhost it only returns and id of 0.
Does anyone else have this problem? How can I correct this?