SOURCEコマンドで長いSQL文をテキストファイルにまとめて実行

例hanbai.sql

use rensyu;
drop table if exists t_hanbai;
CREATE TABLE t_hanbai (
	id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
	ndate DATE NOT NULL,
	tkcd CHAR(4) NOT NULL,
	shcd CHAR(6) NOT NULL,
	suryo SMALLINT NOT NULL,
	PRIMARY KEY(id),
	INDEX(tkcd),
	INDEX(shcd)
)
ENGINE = InnoDB;

INSERT INTO t_hanbai VALUES (1,'2005-07-11','1001','100001',10);
INSERT INTO t_hanbai VALUES (2,'2005-07-12','1001','100101',3);
INSERT INTO t_hanbai VALUES (3,'2005-07-12','1002','100201',5);
INSERT INTO t_hanbai VALUES (4,'2005-07-21','1003','100A01',7);
INSERT INTO t_hanbai VALUES (5,'2005-07-22','1005','100B01',2);

MySQL monitorで読み込む

mysql> SOURCE c:\mysql\txt\hanbai.sql
Database changed
Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.08 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 1 row affected (0.02 sec)

mysql> select * from t_hanbai;
+----+------------+------+--------+-------+
| id | ndate      | tkcd | shcd   | suryo |
+----+------------+------+--------+-------+
|  1 | 2005-07-11 | 1001 | 100001 |    10 |
|  2 | 2005-07-12 | 1001 | 100101 |     3 |
|  3 | 2005-07-12 | 1002 | 100201 |     5 |
|  4 | 2005-07-21 | 1003 | 100A01 |     7 |
|  5 | 2005-07-22 | 1005 | 100B01 |     2 |
+----+------------+------+--------+-------+
5 rows in set (0.00 sec)