last_insert_id() command not working for me!!!

[minht]

Hi there. could somebody help explain why the last_insert_id() command will not work when i use it pls.
I have two tables, one main and the other secondary. The seconday has an main_id column which referecnce the id from the main table. To do this i first insert an entry into the main table. Immediately after the entry i used the following at the command prompt:
select last_insert_id();
but the error i get is
parse error near '()' at line 1
im using mysql distribution 3.20.32a
any help would be most appreciated.
minht@emagen.com.au

 

[Guest_imported]

Hi! I have been using the 3.22.34 stable version and last 3.33.27 version. I never had problem using the select last_insert_id() command. I even use it at Delphi + MySQL application.

Maybe you should upgrad it to a newer version from

http://www.mysql.com.