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, 2019 in Database by Jino
• 5,810 points
407 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, 2019 by Priyaj
• 58,080 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, 2019 in Database by Reshma
709 views
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Open data (Ledger/P&L or Balance Sheet) that ...READ MORE

answered Mar 15 in Database by gaurav
• 13,460 points
107 views
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Tally Data in Excel or PDF: How ...READ MORE

answered Mar 30 in Database by gaurav
• 13,460 points
41 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 Sahiti
• 6,380 points
1,664 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 Sahiti
• 6,380 points
149 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,240 points
1,527 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,240 points
339 views
0 votes
1 answer

How to install MySQL in windows?

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

answered Feb 28, 2019 in Database by Priyaj
• 58,080 points
381 views
0 votes
1 answer

How to install MySQL in Ubuntu?

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

answered Feb 28, 2019 in Database by Priyaj
• 58,080 points
440 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP