CODEWITHSUNDEEP
mysqlinnodb
Manish Pradhan
Manish Pradhan

Reputation: 1188

Can concurrent Inserts result in such a way

I think I am having some problems related to concurrent inserts so I wanted to know if such concurrent insert statements -

insert into table1 (field1,field2,field3) Values (A,B,C);
insert into table1 (field1,field2,field3) Values (1,2,3);

could result in a row like

A B 3

A and B from the first insert statement and the 3 from the second insert statement. My table is using InnoDB storage btw.

Upvotes: 0

Views: 77

Answers (1)

DiverseAndRemote.com
DiverseAndRemote.com

Reputation: 19888

The answer is no. Inserts and updates normally lock the tables/row they are operating on so that won't happen.

Upvotes: 3

Related Questions