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,520 points
58 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
+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,140 points

Related Questions In Database

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
103 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,710 points
89 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
21 views
0 votes
1 answer

How to connect to MySQL Database?

using MySql.Data; using MySql.Data.MySqlClient; namespace Data { ...READ MORE

answered Oct 12, 2018 in Database by Frankie
• 9,710 points
59 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
13 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
63 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
30 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,140 points
17 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,140 points
20 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.