在Mysql数据库增加记录时,如果要一条一条地输入记录,很麻烦的,今天小试一下Mysql导入文本文件,结果正常,操作好下:
创建一个文本文件"mytable.txt",每行包含一条记录,用定位符(tab)把值分开,并且以在create table语句中列出的列次序给出.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| abccs |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use abccs;
Database changed
mysql> LOAD DATA INFILE "mytable.txt" INTO TABLE mytable;
(我是把mytable.txt的文本文件放在data\abccs里面的.如果放在外面要注意路径如:
在D盘的根目录,则:LOAD DATA INFILE "D:\\mytable.txt" INTO TABLE mytable;
若文件没有和路径一致,mysql会找不到文件的)
Query OK, 3 rows affected (0.00 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
mysql> select * from mytable;
+------+------+------------+-----------+
| name | sex | birth | birthaddr |
+------+------+------------+-----------+
| Li | M | 1984-10-23 | china |
|g | M | 1985-07-24 | china
| | M | 1988-03-07 | china
| yang | M | 1987-08-23 | china |
| | M | 1985-07-24 | china
| | M | 1988-03-07 | china
| long | M | 1987-08-23 | china |
| | M | 1985-07-24 | china
| | M | 1988-03-07 | china
| long | M | 1987-08-23 | china |
+------+------+------------+-----------+
10 rows in set (0.00 sec)
OK了!
阅读(5335) | 评论(2) | 转发(0) |