mysql dump table to csv code example

Example 1: mysqldump csv

mysqldump -u username -p -t  -T/path/to/directory dbname table_name --fields-terminated-by=','

Example 2: export mysql table to file

mysqldump db_name tbl_name;