Managing & Using MySQL, 2nd Edition

Name

insert_id( )*

Signature

                        id = cursor.insert_id(  )

Synopsis

Returns the last inserted ID from the most recent INSERT on an AUTO_INCREMENT field.

Example

connection = MySQLdb.connect(host='carthage', user='test', 
                             passwd='test', db='test');
cursor = connection.cursor(  );
cursor.execute("INSERT INTO TNAME (COL) VALUES (1)");
id = cursor.insert_id(  );