Priority « MySQL Utilities « MySQL Tutorial

26.7.1.To force MySQL to perform the SELECT first
26.7.2.Delay an INSERT statement until the table is no longer in use
26.7.3.Execute an UPDATE statement when no one else is using the table
26.7.4.To have a DELETE statement execute while no one else is reading from the table