Copyright (C) 2000-2012 |
GNU Info (mysql.info)ODBC and last_insert_idHow to Get the Value of an `AUTO_INCREMENT' Column in ODBC ---------------------------------------------------------- A common problem is how to get the value of an automatically generated ID from an `INSERT'. With ODBC, you can do something like this (assuming that `auto' is an `AUTO_INCREMENT' field): INSERT INTO foo (auto,text) VALUES(NULL,'text'); SELECT LAST_INSERT_ID(); Or, if you are just going to insert the ID into another table, you can do this: INSERT INTO foo (auto,text) VALUES(NULL,'text'); INSERT INTO foo2 (id,text) VALUES(LAST_INSERT_ID(),'text'); Note: Getting unique ID. For the benefit of some ODBC applications (at least Delphi and Access), the following query can be used to find a newly inserted row: SELECT * FROM tbl_name WHERE auto IS NULL; automatically generated by info2www version 1.2.2.9 |