導入表數據 txt
導入表數據 txt
mysql> load data infile "D:/import.txt" into table shop;
輸出：
Query OK, 5 rows affected (0.08 sec)
Records: 5 Deleted: 0 Skipped: 0 Warnings: 0
txt文檔中內容：
6 bag 180 jd A 500
7 ipad air2 3500 tmall B 500
8 Sony Camera 1800 jd B 200
9 knife 6 tmall A 500
10 shoes 300 jd B 80
導入後查詢數據：
mysql> select * from shop;
輸出：
+----+-------------+---------+---------------+------+-------+
| id | name | price | supplier_name | sort | count |
+----+-------------+---------+---------------+------+-------+
| 1 | apple | 2.50 | dangdang | A | 500 |
| 2 | book | 8.50 | tmall | B | 500 |
| 3 | book | 1.20 | jd | B | 200 |
| 4 | apple | 1.50 | tmall | A | 500 |
| 5 | pen | 8.50 | jd | B | 80 |
| 6 | bag | 180.00 | jd | A | 500 |
| 7 | ipad air2 | 3500.00 | tmall | B | 500 |
| 8 | Sony Camera | 1800.00 | jd | B | 200 |
| 9 | knife | 6.00 | tmall | A | 500 |
| 10 | shoes | 300.00 | jd | B | 80 |
+----+-------------+---------+---------------+------+-------+
10 rows in set (0.00 sec)
