Entry

Do I have to do anything in MySQL to prevent collisions between multiple inserts?

When do I need to lock tables for updating?

May 11th, 2000 17:07
Nathan Wallace, Jonathan Stimmel

As a general rule, no. MySQL insures that only one query can write to a
table at a time. If, however, you need to make changes to two or more
tables without the tables changing between queries, then you will need
to lock the tables you plan to access.