MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Multipline lines insert in a table with Autoincrement field
Posted by: Rick James
Date: March 02, 2013 09:27PM

> breaking the sequence

Tough! Ok, I should not be that brutal. But the fact is, that there are several cases in which AUTO_INCREMENT reserves the right to give you whatever numbers it likes. All it guarantees is that the numbers will be different.

After you INSERT multiple rows (in a single INSERT statement),
SELECT LAST_INSERT_ID()
will return the first id assigned.

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


Subject
Views
Written By
Posted
Multipline lines insert in a table with Autoincrement field
2219
Omer Ntumba
March 02, 2013 12:54AM
Re: Multipline lines insert in a table with Autoincrement field
1017
Peter Brawley
March 02, 2013 03:45AM
Re: Multipline lines insert in a table with Autoincrement field
1138
Rick James
March 02, 2013 09:27PM
Re: Multipline lines insert in a table with Autoincrement field
993
Omer Ntumba
March 03, 2013 12:14AM
Re: Multipline lines insert in a table with Autoincrement field
1147
Peter Brawley
March 03, 2013 12:50AM
Re: Multipline lines insert in a table with Autoincrement field
1009
Omer Ntumba
March 05, 2013 10:51AM
Re: Multipline lines insert in a table with Autoincrement field
905
Omer Ntumba
March 03, 2013 12:07AM


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.