mysqldump

Here are the ways you can export tables and databases, each of them have their advantages and disadvantages depending on the task at hand. We will list out each with examples and discuss them. We will assume that the database name is D and table name is T. Going native with SQL and generating an csv from the MySQL console Assuming that you are already logged into your mysql console using say mysql -u -p replace with your username replace with your database You can use the following command to generate an csv of pretty much any SQL....