在尝试用msyqldump从MS SQL Azure数据库导入到MySQL时遇到1064错误。错误提示SQL语法错误。解决方案是检查存储过程是否声明了自定义分隔符，因为这可能是当引擎无法确定如何结束语句时出现的错误。建议在创建存储过程时使用自定义DELIMITER。
I am trying to populate a new MySQL empty database with a db dump created from MS SQL Azure database, and I get the following error
ERROR 1064 (42000) at line 1: 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 'I ' at line 1
I used mysqldump to perform this operation and used command similar to the following in the command prompt:
mysql --user=rootusername --pasword=password databasename < dumpfilename.sql
Mysqldump took about 30 minutes to display this error message.
解决方案
(For those coming to this question from a search engine), check that your stored procedures declare a custom delimiter, as this is the error that you mig
最低0.47元/天 解锁文章
4405
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
