How to export data from MySql to a CSV file?

+2 votes
I have a table in Mysql and I want to export the data to a csv file. How can I do that? Can someone help me with this?

Thank you in advance.
Jan 4 in Database by Jino
• 5,560 points
69 views

1 answer to this question.

+2 votes

If you are using MySql workbench then exporting data from a table is just a matter of few clicks. All you need to know is which table's data you need, what number of rows and columns you want and how your data is going to be exported. 

Here is an elaborate screenshot of the process:-

Step 1:- Choose the table you want your data from. Here I need my data from record1 table.

Step 2:- Right-click on your table and click on Export Data wizard.

Step 3:- Check which columns you need to be exported and click on next.

Step 4:- Select the path where you want to save the file, select the way your file should look like and click on next.

Step 5:- Everything is ready click on next.

Step 6:- Wait for few minutes, you can also see the progress bar and logs of data being exported.

Step 7:- Everything is complete just click on next.

Step 8:- Everything is done you can see the number of rows that is exported. Click on finish.

Done, you will have your exported file in the directory you mentioned. Hope this helps.

answered Jan 4 by Priyaj
• 56,200 points

Related Questions In Database

0 votes
1 answer

How to load data of .csv file in MySQL Database Table?

At first, put the dataset in the ...READ MORE

answered Jul 5 in Database by Reshma
35 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
182 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,810 points
176 views
0 votes
1 answer

How to display the queries executed by a particular user in MySQL?

From the version 5.1.7 onward, MySQL allows ...READ MORE

answered Mar 7 in Database by Mishti
• 480 points
32 views
0 votes
1 answer

What is MySQL Workbench?

MySQL Workbench is a designing or a ...READ MORE

answered Nov 29, 2018 in Database by darklord
• 6,140 points
18 views
0 votes
1 answer
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,100 points
109 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,100 points
37 views
0 votes
1 answer

How to install MySQL in windows?

You can download the all in one ...READ MORE

answered Feb 27 in Database by Priyaj
• 56,200 points
24 views
0 votes
1 answer

How to install MySQL in Ubuntu?

To install MySQL on ubuntu you have ...READ MORE

answered Feb 28 in Database by Priyaj
• 56,200 points
44 views