mysql 备份数据有错_导入一个备份数据库出现1064错误（mysql数据库）

最新推荐文章于 2024-07-03 16:39:32 发布

乌贼ichabod

最新推荐文章于 2024-07-03 16:39:32 发布

阅读量296

点赞数

文章标签： mysql 备份数据有错

本文链接：https://blog.csdn.net/weixin_34422394/article/details/113297075

版权

这篇博客讨论了遇到MySQL语法错误，特别是与IF EXISTS相关的语法在旧版本服务器上不被支持的问题。作者提到了在删除触发器时遇到的错误提示，并暗示了解决此类问题可能需要查阅相应MySQL版本的手册，更新或调整SQL语句以适应服务器的兼容性。

摘要由CSDN通过智能技术生成

[Err]1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'IFEXISTS`beforeinsertintocardtransactions`'atline1...

[Err] 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 'IF EXISTS `beforeinsertintocardtransactions`' at line 1

[Err] DROP TRIGGER IF EXISTS `beforeinsertintocardtransactions`;

[Err] 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 'IF EXISTS `updategoodsprice`' at line 1

[Err] DROP TRIGGER IF EXISTS `updategoodsprice`;

[Err] 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 'IF EXISTS `beforeinsertintogoodscostaccount`' at line 1

[Err] DROP TRIGGER IF EXISTS `beforeinsertintogoodscostaccount`;

[Msg] Finished - Unsuccessfully

--------------------------------------------------

这个是MySQL服务器的软件过老！

展开