Home  >  Article  >  Database  >  导入表数据 txt_MySQL

导入表数据 txt_MySQL

WBOY
WBOYOriginal
2016-05-30 17:11:06948browse

导入表数据 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)

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn