last inserted ID number (mysql)

[angor]

could you please help me to get the ID of the last inserted row in the table?..
e.g.

INSERT INTO table1 (ID,name,surname) values ('null','My_name','My_surname')


where ID is AUTO_INCREMENT field.
Thank you.
Andrew

 

[r937]

why is this in the microsoft access forum?

use the mysql_insert_id() function

r937.com | rudy.ca

 

[LittleSmudge]

I use

dim rst as new ado.recordset
etc.
rst.ActiveConnection = {connection to MySQL}

rst.Open "SELECT Last_Insert_Id() As NewId"
lngNewId = rst!NewId

rst.close
etc..


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.