- 论坛徽章:
- 1
|
回复 1# tahaomei
delimiter //
create database IF NOT EXISTS dbname;
use dbname;
create table IF NOT EXISTS tablename ( id int not null auto_increment primary key, code int(6) not null, name varchar(40) not null ) comment='股票代码及名称表' engine=InnoDB;
load data local infile "/your path/sha.txt" into table tablename fields terminated by ';' lines terminated by '\n' (name, code)
//
参数列表要在terminated by子语句后面,不知道你在哪里看的网上示例,如果语法不清除可以多参看Mysql的官方文档:
http://dev.mysql.com/doc/refman/5.5/en/load-data.html
上面的例子说的很清楚了:- LOAD DATA LOCAL INFILE 'C:/path/to/mytable.txt' IGNORE
- INTO TABLE mytable
- FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'
- (int_col, @float_col)
- SET float_col = replace(@float_col, ',', '.');
复制代码 另外lines terminated的地方,如果是windows请用\r\n,linux请用\n,mac的也许是\r,自己试试吧,还有什么语法上的疑问都可以在文档上找到答案的。
我运行成功的终端截图:- mysql> delimiter //
- mysql> create database IF NOT EXISTS dbname; use dbname; create table IF NOT EXISTS tablename ( id int not null auto_increment primary key, code int(6) not null, name varchar(40) not null ) comment='股票代码及名称表' engine=InnoDB; load data local infile "/home/homisunit/Documents/StaDB/sha.txt" into table tablename fields terminated by ';' lines terminated by '\n' (name, code)//
- Query OK, 1 row affected (0.00 sec)
- Query OK, 0 rows affected (0.00 sec)
- Query OK, 0 rows affected (0.24 sec)
- Query OK, 11 rows affected (0.36 sec)
- Records: 11 Deleted: 0 Skipped: 0 Warnings: 0
- mysql> select * from tablename//
- +----+--------+--------------+
- | id | code | name |
- +----+--------+--------------+
- | 1 | 600093 | 禾嘉股份 |
- | 2 | 600094 | 大名城 |
- | 3 | 600095 | 哈高科 |
- | 4 | 600096 | 云天化 |
- | 5 | 600097 | 开创国际 |
- | 6 | 600098 | 广州发展 |
- | 7 | 600099 | 林海股份 |
- | 8 | 600100 | 同方股份 |
- | 9 | 600101 | 明星电力 |
- | 10 | 600102 | 莱钢股份 |
- | 11 | 600103 | 青山纸业 |
- +----+--------+--------------+
- 11 rows in set (0.00 sec)
复制代码 |
|