1、Windows下MySql批处理命令
mysql>\. d:\mysqlscript.sql [回车]
或
mysql>source d:\mysqlscript.sql [回车]
或
mysql>source d:\mysqlscript.sql [回车]
2、批量导入以tab键为间隔的数据
mysql> LOAD DATA LOCAL INFILE 'C:/temp/pet.txt' INTO TABLE pet LINES TERMINATED BY '\r\n';
以下是pet表和要导入的数据的说明
1)pet表:
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
2)需要导入的数据文件“pet.txt”,其中 的“\N"表示null
Buffy Harold dog f 1989-05-13 \N
Fang Benny dog m 1990-08-27 \N
Bowser Diane dog m 1979-08-31 1995-07-29
Chirpy Gwen bird f 1998-09-11 \N
Whistler Gwen bird \N 1997-12-09 \N
SlimBenny snake m 1996-04-29 \N
Fang Benny dog m 1990-08-27 \N
Bowser Diane dog m 1979-08-31 1995-07-29
Chirpy Gwen bird f 1998-09-11 \N
Whistler Gwen bird \N 1997-12-09 \N
SlimBenny snake m 1996-04-29 \N
注:附件是pet.txt
3、使用用户变量
你可以清空MySQL用户变量以记录结果,不必将它们保存到客户端的临时变量中。(参见 9.3节,“用户变量”.)。
mysql> SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop;
mysql> SELECT * FROM shop WHERE price=@min_price OR price=@max_price;
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
| 0003 | D | 1.25 |
| 0004 | D | 19.95 |
+---------+--------+-------+
mysql> SELECT * FROM shop WHERE price=@min_price OR price=@max_price;
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
| 0003 | D | 1.25 |
| 0004 | D | 19.95 |
+---------+--------+-------+