I need to export certain column only of a database table to csv file.

Here is the format of the source:

ID | user_email | user_login | user_nickname | usergroup | address | user_registered | user_url

And this should be the output format:

ID | user_login | user_nickname | user_email | user_url | user_registered

Thank you!

  • Can you provide more information please? Like what have you tried already, what errors (if any) are you getting? Share any code you may have. People are more willing to help you if you have at least attempted to do it yourself. – Mr.Brownstone Jan 31 '18 at 15:08

SELECT ((just those columns)) INTO OUTFILE ...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.