Export mysql tables in .txt files

mysql> use test;

mysql> SELECT *FROM example;

+------+--------+-----------+----------------+

| ID   | NAME   | ADDRESS   | REMARKS        |

+------+--------+-----------+----------------+

|    1 | SANJAY | AHMEDABAD | SYSTEM ADMIN   |

|    1 | PRIYA  | PUNE      | PERL DEVELOPER |

|    1 | AKSHAY | GONDAL    | PERL DEVELOPER |

|    1 | MIHIR  | MUMBAI    | PERL DEVELOPER |

+------+--------+-----------+----------------+

4 rows in set (0.00 sec)

#mysqldump -u root -p --fields-terminated-by=, --tab=/location --table test example 

Above command will create the file example.txt which contains the export data in /location directory

Output: example.txt

#cat /location/example.txt

1,SANJAY,AHMEDABAD,SYSTEM ADMIN

1,PRIYA,PUNE,PERL DEVELOPER

1,AKSHAY,GONDAL,PERL DEVELOPER

1,MIHIR,MUMBAI,PERL DEVELOPER