Table locking question

[Chris Vasquez]

Hi All,

Just wondering about table locking.

I learnt many years ago while using flat files that I need to open them and close them in order

Open File 1
Open File 2

Close File 2
Close File 1

I Found That If I Did

Open File 1
Open FIle 2

Close File 1
Close File 2

I would occasionally get 2 users in an infiniate loop. One waiting to open file 1 and the other waiting for file 2.

How does MYSQL handle table locking, do I need to worry about the locking order.

Thanks