☰
✕
✕
0

Cannot drop a table in MySQL Database

I can' t delete a Table inside my MySQL Database and i am getting the below error

mysql>  drop database postfix 
ERROR 1192 (HY000): Can' t execute the given command because you have active locked tables or an active transaction
Database MySQL
Add a comment
stewart
asked Feb 14 2018

Answer

0

You cannot drop a database if the table is locked, use the below command to unlock the table and then try removing the database

UNLOCK TABLES;
Add a comment
parthiban
asked Feb 14 2018
edited Oct 05 2018
Post your Answer