So if I have multiple users accessing the same DB I should use LOCK tables to secure data integrity, but lock tables just refuses the query from the 2nd user. What method should I use to ensure that the 2nd user's query is executed?
Normally locking tables is unnecessary, unless you want to make a number of changes and not allow another process to see things "in between". Even in that case, using transactions may be preferable.
Mark
