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
精彩评论