错误代码: 1100 Table 't_depart_info' was not locked with LOCK TABLES

来源:互联网 时间:1970-01-01

1、错误描述

1 queries executed, 0 success, 1 errors, 0 warnings查询:insert into emp values(11,'h',23,'女')错误代码: 1100Table 't_depart_info' was not locked with LOCK TABLES执行耗时 : 0 sec传送时间 : 0 sec总耗时 : 0 sec
2、错误原因

     将emp数据库表READ锁定:LOCK TABLE emp READ;

     在向emp插入数据,并调用触发器insert_data

DELIMITER $$USE `test`$$DROP TRIGGER /*!50032 IF EXISTS */ `insert_data`$$CREATE /*!50017 DEFINER = 'root'@'localhost' */ TRIGGER `insert_data` BEFORE INSERT ON `emp` FOR EACH ROW BEGIN INSERT INTO t_depart_info(id,depart_name,depart_teacher) VALUES(7,'hai','hugang'); END;$$DELIMITER ;


3、解决办法

     释放锁

UNLOCK TABLES;



相关阅读:
Top