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

我们可以利用mysql 命令模式来导入或导出csv文件哦，有需要的朋友可以简单的参考一下。

> * from tt_address;

+-----+-----+--------+--------+------+--------+------------+-------------+------

-----+----------+-------+------------------------+-------+--------+-----+-------

--+----------+------+---------+------+-----+--------+---------+-------+-----+---

------+-------------+--------------+---------------------------+----------------

-------+

| uid | pid | tstamp | hidden | name | gender | first_name | middle_name | last_

name | birthday | title | email | phone | mobile | www | addres

s | building | room | company | city | zip | region | country | image | fax | de

leted | description | addressgroup | module_sys_dmail_category | module_sys_dmai

l_html |

+-----+-----+--------+--------+------+--------+------------+-------------+------

-----+----------+-------+------------------------+-------+--------+-----+-------

--+----------+------+---------+------+-----+--------+---------+-------+-----+---

------+-------------+--------------+---------------------------+----------------

-------+

| 2 | 42 | 0 | 1 | | m | aa | | aa

| 0 | | tian.li@atop-online.de | | | |

| d | | | | | | | | |

0 | | 0 | 0 |

0 |

+-----+-----+--------+--------+------+--------+------------+-------------+------

-----+----------+-------+------------------------+-------+--------+-----+-------

--+----------+------+---------+------+-----+--------+---------+-------+-----+---

------+-------------+--------------+---------------------------+----------------

-------+

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 ---- 行终止符

本文原创发布php中文网，转载请注明出处，感谢您的尊重！