DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) ODBC and last_insert_id

Info Catalog (mysql.info.gz) Functionality (mysql.info.gz) Functionality (mysql.info.gz) 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');
 
  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.gz) Functionality (mysql.info.gz) Functionality (mysql.info.gz) Dynamic Cursor
automatically generated byinfo2html