MySQL server version for the right syntax to use near—

今天打算在一台freebsd服务器上开通pureftp,参照文章“pureftp安装笔记”进行到mysql -u root -p < script.mysql步骤时提示以下错误信息: [root@www.service-labs.com ~]# mysql -u root -p < script.mysql Enter password: ERROR 1064 (42000) at line 15: 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 '------------------------------------------------------- INSERT INTO m' at line 1 我就奇怪了,以前一直照此文的方法都没出现过错误的,怎么这回就出问题了,唯一的区别就是这个系统是freebsd 8.1版本,mysql版本是5.0,难道是此版本不支持"--------"语法?按照提示vi +15 script.mysql删除"------"这一行,再次执行命令:mysql -u root -p < script.mysql通过!OK,问题解决!

上一篇: