mysql执行sql脚本

一种方法是：

具体格式：source F:\a\chart_config.sql             执行的脚本在F盘里的文件夹a里面。

具体例子：

mysql> use bbs;
Database changed


mysql> source F:\a\chart_config.sql
Query OK, 0 rows affected (0.00 sec)


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


Query OK, 0 rows affected (0.20 sec)


Query OK, 1 row affected (0.07 sec)


mysql> source F:\a\data_grid.sql
Query OK, 0 rows affected (0.00 sec)


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


Query OK, 0 rows affected (0.22 sec)


Query OK, 1 row affected (0.06 sec)


mysql> source F:\a\data_grid_more.sql
Query OK, 0 rows affected (0.00 sec)


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


Query OK, 0 rows affected (0.20 sec)


执行完之后查看结果：
mysql> show tables;
+----------------+
| Tables_in_bbs  |
+----------------+
| bbs_forum      |
| bbs_info       |
| chart_config   |
| data_grid      |
| data_grid_more |
+----------------+
5 rows in set (0.04 sec)


mysql>