MySQL Forums
Forum List  »  MyISAM

Is a multiple INSERT atomic?
Posted by: medi !
Date: February 15, 2010 09:39AM

Hi folks,

is an INSERT like this one:
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
atomic?

Or in other words. Is it guaranteed that the AUTO_INCREMENT values are sequentially?
e.g. 1,2,3 and not 1,2,4
Or should I use LOCK/UNLOCK TABLES?

I found nothing about this in the documentation.

ty
medi

Options: ReplyQuote


Subject
Views
Written By
Posted
Is a multiple INSERT atomic?
7851
February 15, 2010 09:39AM
3577
February 17, 2010 09:35AM
3127
February 17, 2010 10:44AM


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.