Failure of UNLOCK TABLES query?

[Anon]

Hi,

i wanted to know what would happen if i lock some table in mysql and then my script fails at the Unlock Tables query. Does the table remain locked forever or is there a timeout for the locking of the tables?

thanks for any reply
steve

[[deleted]]

Manuals are your friends, read them.

Tables are locked per database connection.
When the database connection is closed, all locks created by that connection are released.