CODEWITHSUNDEEP
mysqldatabase
Icosahedron
Icosahedron

Reputation: 30

What happen if two or more user send insert query for same table in mysql?

  1. Does MySql put their queries in something like a queue or one of the queries will be accepted and other ones receive an error?

  2. If there is something like a queue, what is its basis? does it work on based on time or something else?

Update: I supposed that every query is unique and happen to be a new record.

Upvotes: 0

Views: 453

Answers (1)

O. Jones
O. Jones

Reputation: 108816

For ordinary insert queries of the type that can never create a duplicate key value, SQL table servers (MySQL and the rest) always perform them all.

You can think of the table server as containing a query queue: that's useful even if it is greatly oversimplified. Modern table servers contain vast amounts of code oriented around handling concurrent users correctly.

When two users issue queries at nearly the same time, you cannot rely on the table server to perform them in a particular order, just that they will all complete correctly.

Read up on ACID.

Upvotes: 1

Related Questions