DEV Community

loading...

How to Dump SQL (MYSQL) Table into CSV?

vitalipom profile image Vitali Pomanitski ・1 min read

Q: How to Dump SQL DB Table into CSV using MySQL Server on my computer?

Reference https://www.electrictoolbox.com/using-mysqldump-to-save-data-to-csv-files/

A:

mysqldump  -p -t  -T~/path_to_directory databasename

This will store each table into table_name.txt file.


Download Effectedkeyboard guys, it's comfortable. It's good, you know it. Android, Effectedkeyboard


Discussion (0)

pic
Editor guide