MySQL Workbench is a good tool to use and manipulate the data in the MySQL database using the tool called - MySQL workbench. When you are working with the MySQL then you have this tool that would do most of the work for you. And you don't have to use the Shell for working with database in that case, everything in front of you visible.
This tool is free of cost, you can use it to connect to the local database and even the cloud database. This way you would be able to connect to the database and get the results as and when required. I have found out this tool to be working out for me.
So here in this tutorial I am going to show you how you can use this tool for exporting the data to the variety of the formats like - txt, json, csv and sql file too.
You can download the MySQL Workbench from here.
Once you setup and it loading you would have the interface where you would have to connect to the database. You would choose to use either local mysql database or the cloud, either would work out for you.
I assume you have some database already attached to the mysql database. And you have created a table which you can access with some rows of data. That would allow you to make use of the queries that would put out the results through the Workbench. You may want to make use of the query to such table something like below.
SELECT * FROM mydatabase.mytable;
and it is for reference below:
This should show you all the rows of the data from the table of the database. That would also show you this query windows. And then we want to take out the data of those query into the variety of the formats.
Here the formats allowed to be exported are - html, sql, json, XML, tsv and excel spreadsheet. This would be a good format for you to work with the data as other formats are not allowed for export and import either. So hopefully you can use the steps through this for the export too and get in the result.
Once your work is done, go to the Server menu and then use the Start/Shutdown. This should work out for you in context of the closing the connection to the server.
I hope that you have found this tutorial useful. Make sure to check out the above tutorial in the video format so that you can get the idea of how to use the MySQL Workbench in the video form and you would be able to make use of it for the export of the data. Please like, share and subscribe to the channel and that you would be getting notified when the new videos come into the channel.
I hope to cover more of the visual studio and other tutorials next week :)
Thanks for your contribution to the STEMsocial community. Feel free to join us on discord to get to know the rest of us!
Please consider delegating to the @stemsocial account (85% of the curation rewards are returned).
You may also include @stemsocial as a beneficiary of the rewards of this post to get a stronger support.