how to export a csv using INTO syntax of mysql

[rajasri]

Guys if you want to study mysql from scratch click the above mysql tab.
Here we are going to learn how to export a database table as a csv file in mysql.
Assuming you have a table "login" or just create a table login or whatever name.
Create table login(name varchar(20),pass varchar(20));
then insert some values.

In mysql console type as shown below.

mysql> select * from login into outfile 'c:/login.csv' fields
terminated by ',
'enclosed by '"'lines terminated by "";

Now you will find csv file in c:/login.csv. Any doubts ask us.

Happy coding