mercredi 5 août 2015

How to check specific table is locked in Mysql?


I am executing below query to find the whether my temp table is locked.

show open tables where in_use > 0 and table = 'temp'

But it throwing below error :

Syntax error near 'table = 'temp'

I have searched but unable to get the correct syntax. Can anybody help.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire