MySQL 数据库 source 命令详解_MsSql

mysql> use test
 
Database changed
 
mysql> set names utf8;
 
Query OK, 0 rows affected (0.00 sec)
 
mysql> source C:/test.sql
 
Query OK, 0 rows affected (0.00 sec)
 
Query OK, 0 rows affected (0.33 sec)
 
Query OK, 0 rows affected (0.07 sec)
 
Query OK, 1 row affected (0.02 sec)
 
Query OK, 1 row affected (0.03 sec)
 
Query OK, 1 row affected (0.02 sec)
 
mysql> set names gbk;
 
Query OK, 0 rows affected (0.00 sec)

mysql> source C:/test.sql

mysql> set names utf8;
mysql> source C:/test.sql

mysql> set names gbk;
 
mysql> select * from user;