DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) odbc-and-last-insert-id

Info Catalog (mysql.info) functionality (mysql.info) functionality (mysql.info) dynamic-cursor
 
 23.1.14.1 How 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' statement. With ODBC, you can do something like
 this (assuming that `auto' is an `AUTO_INCREMENT' field):
 
      INSERT INTO tbl (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 tbl (auto,text) VALUES(NULL,'text');
      INSERT INTO tbl2 (id,text) VALUES(LAST_INSERT_ID(),'text');
 
 See  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 WHERE auto IS NULL;
 
Info Catalog (mysql.info) functionality (mysql.info) functionality (mysql.info) dynamic-cursor
automatically generated byinfo2html