錯(cuò)誤代碼：1100 Table 't_depart_info' was not locked with LOCK TABLES的解決方法

1 queries executed, 0 success, 1 errors, 0 warnings 
 
查詢：insert into emp values(11,'h',23,'女') 
 
錯(cuò)誤代碼： 1100 
Table 't_depart_info' was not locked with LOCK TABLES 
 
執(zhí)行耗時(shí) : 0 sec 
傳送時(shí)間 : 0 sec 
總耗時(shí) : 0 sec 

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 ;