mysql命令模式导出导入csv文件代码

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

1. mysql>select*fromtt_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. 1rowinset(0.00sec)

这个表里的只有一条数据,现在我导出的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 ---- 行终止符.