Error Code: 1360 - Trigger does not existQuery

最新推荐文章于 2023-04-17 19:30:08 发布

最新推荐文章于 2023-04-17 19:30:08 发布 · 1.4k 阅读

文章标签：

#数据库

本文记录了在MySQL中遇到的触发器不存在及表结构定义错误的问题，并提供了具体的解决办法。错误包括尝试删除不存在的触发器以及修改不存在的表结构。

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、解决办法

重新运行脚本