导入表数据 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 5007 ipad air2 3500 tmall B 500 8 Sony Camera 1800 jd B 200 9 knife 6 tmall A 50010 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 | kni<p style="color:transparent">本文来源gao!%daima.com搞$代*!码$网3</p>fe | 6.00 | tmall | A | 500 | | 10 | shoes | 300.00 | jd | B | 80 |+----+-------------+---------+---------------+------+-------+10 rows in set (0.00 sec)
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：导入表数据 txt_MySQL
转载请注明原文链接：导入表数据 txt_MySQL
