56,677
社区成员
发帖
与我相关
我的任务
分享
mysql>create table tb_insert(memo varchar(50),total int);
mysql> load data infile "d:\\phone.txt" into table tb_insert fields terminated
y ',' lines terminated by '\r\n';
Query OK, 4 rows affected (0.00 sec)
Records: 4 Deleted: 0 Skipped: 0 Warnings: 0
mysql> select * from tb_insert;
+-------------+-------+
| memo | total |
+-------------+-------+
| 13570105253 | 100 |
| sdfsddsfdsf | 200 |
| ewweweewew | 300 |
| wewewewe | 400 |
+-------------+-------+
4 rows in set (0.00 sec)
mysql>