我们可以利用mysql 命令模式来导入或导出csv文件,有需要的朋友可以简单的参考一下,代码如下:

1. mysql> select * from tt_address; 
2. +-----+-----+--------+--------+------+--------+------------+-------------+------ 
3. -----+----------+-------+------------------------+-------+--------+-----+------- 
4. --+----------+------+---------+------+-----+--------+---------+-------+-----+--- 
5. ------+-------------+--------------+---------------------------+---------------- 
6. -------+ 
7. | uid | pid | tstamp | hidden | name | gender | first_name | middle_name | last_ 
8. name | birthday | title | email                  | phone | mobile | www | addres 
9. s | building | room | company | city | zip | region | country | image | fax | de 
10. leted | description | addressgroup | module_sys_dmail_category | module_sys_dmai 
11. l_html | 
12. +-----+-----+--------+--------+------+--------+------------+-------------+------ 
13. -----+----------+-------+------------------------+-------+--------+-----+------- 
14. --+----------+------+---------+------+-----+--------+---------+-------+-----+--- 
15. ------+-------------+--------------+---------------------------+---------------- 
16. -------+ 
17. |   2 |  42 |      0 |      1 |      | m      | aa         |             | aa 
18.      |        0 |       | tian.li@atop-online.de |       |        |     | 
19.   | d        |      |         |      |     |        |         |       |     | 
20.     0 |             |            0 |                         0 | 
21.      0 | 
22. +-----+-----+--------+--------+------+--------+------------+-------------+------ 
23. -----+----------+-------+------------------------+-------+--------+-----+------- 
24. --+----------+------+---------+------+-----+--------+---------+-------+-----+--- 
25. ------+-------------+--------------+---------------------------+---------------- 
26. -------+  --phpfensi.com 
27. 1 row in set (0.00 sec) 

这个表里的只有一条数据,现在我导出的csv文件里只需要有uid,name,gender,email,module_sys_dmail_html.命令行如下：select uid,name,gender,email,module_sys_dmail_html into outfile 'd:\test7.csv' fields terminated by ',' optionally enclosed by '"' lines terminated by 'n' from tt_address

cvs文件导入MySql数据库命令:

mysql> load data local infile 'e:\input1.csv' into table test1 fields terminated by ','lines terminated by 'n'(first_name,last_name,email);

FIELDS TERMINATED BY ---- 字段终止字符.

FIELDS OPTIONALLY ENCLOSED BY ---- 封套符.

LINES TERMINATED BY ---- 行终止符.

Tags: mysql命令模式 mysql导入csv

分享到：