mysql 导入数据 source

mysql导入sql数据，

set names utf8;解决utf8格式sql导入乱码问题

mysql>set names utf8;

mysql>source H:\www\test.sql

结果：

Query OK, 1 row affected (0.03 sec)


Query OK, 0 rows affected, 1 warning (0.04 sec)


Query OK, 0 rows affected (0.06 sec)


Query OK, 1 row affected (0.04 sec)


Query OK, 1 row affected (0.02 sec)


Query OK, 1 row affected (0.05 sec)