开发者

How can I export just a single field from MySQL?

Rather than export the entire table, that is, fname, lname, address, email, etc. how can I export JUST the email field to CS开发者_Go百科V or Excel?


You can query the database and export the result.

Example: SELECT fname FROM users INTO OUTFILE '/tmp/result.csv' directly from mysql command line

or

SELECT fname FROM users and export the result of this query from your favorite mysql client

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜