解决办法:
1.在sql脚本开头插入下面代码
SET FOREIGN_KEY_CHECKS=0;select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
2.使用数据库管理工具导入mysql
3. 赋值utf-8
mysql -u root –p
show database;
use mytest;
set names utf8;
sourced:\test.sql