MySQL Forums
Forum List  »  Connector/Python

Advanced Search
New Topic

Re: mysql transactions - foreign key failure (update: actually LAST_INSERT_ID() issue)
Posted by: Aaron Peachey
Date: September 27, 2009 06:40AM

OK, I've done some more traces in my code and found the reason for the foreign key errors is actually that my "select LAST_INSERT_ID()" is returning the total number of rows in the table + 1, not the id generated by the auto-increment.

e.g.
I insert a row which will atuo-increment to 227 but there are only 219 rows in the table so the LAST_INSERT_ID() is coming back as 220.
Any idea why and how to fix this?

thanks again
Aaron

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
mysql transactions - foreign key failure
Aaron Peachey
September 27, 2009 05:40AM
Re: mysql transactions - foreign key failure (update: actually LAST_INSERT_ID() issue)
Aaron Peachey
September 27, 2009 06:40AM
Re: mysql transactions - foreign key failure (update: actually LAST_INSERT_ID() issue)
Geert Vanderkelen
September 28, 2009 06:03AM
Re: mysql transactions - foreign key failure (update: actually LAST_INSERT_ID() issue)
Aaron Peachey
October 01, 2009 05:51AM
Re: mysql transactions - foreign key failure
Geert Vanderkelen
September 28, 2009 05:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.