ERROR 1100 (HY000): Table 'api_category' was not locked with

mysql> show create table api_category;
ERROR 1100 (HY000): Table 'api_category' was not locked with LOCK TABLES

字面意思:表“api_category”未用锁表锁定

两个命令解决:

LOCK TABLES `api_category` WRITE; #给表加锁

UNLOCK TABLES;  #给表解锁

 

posted @ 2019-10-11 10:21  码农编程进阶笔记  阅读(7)  评论(0编辑  收藏  举报
返回顶部 有事您Q我