one piece

MYSQL导入数据报错:DEFAULT CHARSET=latin1的解决方法

一般错误描述为:

引用内容
MySQL Server Error:
You have an error in your SQL syntax near ‘ENGINE=MyISAM DEFAULT CHARSET=latin1’ at line 1( 1064 )

或者

引用内容
MySQL Server Error:
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 ‘ENGINE=InnoDB DEFAULT CHARSET=latin1’ at line 1 ( 1064 )
这类错误是由于导出的数据用的是不同版本的MYSQL导入导致的,完美解决方法:

用写字板或者记事本打开并查找你导出的SQL文件或者SQL语句,把
程序代码
ENGINE=MyISAM DEFAULT CHARSET=latin1
或者
程序代码
ENGINE=InnoDB DEFAULT CHARSET=latin1
全部替换为
程序代码
ENGINE=MyISAM
然后保存再导入就可以了!

Created By: sb123

Form Page: MYSQL导入数据报错:DEFAULT CHARSET=latin1的解决方法


One Response to “MYSQL导入数据报错:DEFAULT CHARSET=latin1的解决方法”

  1. cheap wow gold
    二月 23rd, 2010 16:59
    1

Leave a Reply

You must be logged in to post a comment.