MySQL question reguarding LOCKS

[Haleden]

In the following situation:

mysql> LOCK TABLES user_db WRITE;

mysql> SELECT data_1,data_2,data_3 FROM user_db WHERE data_4=some_data;

mysql> SELECT data_1,data_2,data_3 FROM user_db WHERE data_4=some_other_data;

mysql> UPDATE user_db SET data_5=new_data;

mysql> UNLOCK TABLES;

What will be the order of execution?

[Haleden]

Someone please answer me!

[website]

You know there does exist a MySQL forum.

[Haleden]

didn't know that...

[Haleden]

Argh... posts never take this long to be answered! Doesn't anyone know?

[MattR]

What do you mean? They will be performed in the order you execute them -- e.g. sequentially.