MySQL如何通过导入本地.sql文件创建关系表

进入mysql控制台

$ mysql -u root -p
Enter password: ******

打开xxx数据库

mysql> use xxx(数据库名称);
Database changed

导入.sql文件

mysql> source D:\NoSpace\mybatis_test.sql; # 最好使用全英文路径，中文可能出错

Query OK, 0 rows affected, 1 warning (0.07 sec)
Query OK, 0 rows affected (0.00 sec)
...
Query OK, 0 rows affected (0.00 sec)

结果

mysql> show tables;
							+------------------------+
							| Tables_in_mybatis_test |
							+------------------------+
							| batch                  |
							| batchdetail            |
							| customer               |
							| finacial_products      |
							| gameplayer             |
							| magician_info          |
							| pro_mapping_usr        |
							| product                |
							| user                   |
							| users                  |
							| warrior_info           |
							+------------------------+