Exporting a .CSV file based on user requirement is very easy in MySQL.
A simple query could generate your desired output as .CSV file. Let’s see what that command is
[root@localhost]$ mysql -u [username] -p [password]
[root@localhost]$ use [my_database]
[root@localhost]$ SELECT * INTO OUTFILE ‘/userinfo.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”” ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\n’ FROM Table_Users;
Voila! You have your desired results in as a .csv file.
In the next article, we will discuss on how we can import data from .csv file back into database.
