1、错误描述
Query: DROP TRIGGER `t_sert_cs_approve` Error occured at:2015-04-12 13:37:32 Line no.:1 Error Code: 1360 - Trigger does not existQuery: ALTER TABLE `t_toot_erth_ssess` MODIFY COLUMN `id` int(20) NOT NULL AUTO_INCREMENT FIRST , ADD PRIMARY KEY (`id`) Error occured at:2015-04-12 13:40:34 Line no.:3 Error Code: 1146 - Table 'test.t_toot_erth_ssess' doesn't existQuery: DROP TRIGGER `t_sert_cs_approve` Error occured at:2015-04-12 13:40:58 Line no.:1 Error Code: 1360 - Trigger does not existQuery: Error occured at:2015-04-13 09:52:32 Line no.:2938 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2Query: Error occured at:2015-04-13 09:53:02 Line no.:2938 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
2、错误原因
触发器不存在
3、解决办法
重新运行脚本