CSV or SQL? SQL or CSV? How about together? Without a doubt, CSV’s are one of the most common and familiar data interchange formats. Importing and exporting CSV data into or out of an SQL database is a staple process in most every data workflow. I’ve written numerous blog posts on both importing and exporting CSV data in an SQL environment. In this post, I am including all of these specific posts (as of the time of writing) in one easy-to-read and centralized location…
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
Export Query Results to CSV with SQL Developer
One of the most universal data interchange formats in the world is the CSV file. Data professionals use CSV’s without a thought. Equally, those not even in the ‘data field’ use CSV’s on a daily basis. Do you have the SQL query results for that report and need to share them in CSV format? Using the Oracle SQL Developer IDE, it is a breeze…
Import CSV file with Oracle SQL Developer
If you’re working with Oracle SQL and need to load CSV data into one of your tables, using Oracle SQL Developer makes this process a breeze. Continue reading to see a simple example and learn how…
Import CSV file with MySQL Workbench
CSV imports with MySQL Workbench, is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying that importing CSV data into MySQL is a staple task for all DBA’s and Developers. Continue reading to learn how easy it is using MySQL Workbench…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Export MySQL data to CSV with phpMyAdmin
Comma-separated values files – also known as CSV’s – are one of the most recognized and used data storage/exchange formats. Whether a CSV is the best choice or not remains to be seen. For some data, a CSV is fine. For others, not so much. At some point, chances are someone will need data from a MySQL database in CSV format. That’s not at all difficult and there are several ways to do that. What if you are working in the phpMyAdmin interface? Can you export CSV’s from the phpMyAdmin environment? You sure can. Continue reading to see simple examples of exporting MySQL table data to a CSV file using phpMyAdmin…
Import CSV file data into MySQL table with phpMyAdmin
In the blog post MySQL CREATE TABLE in PHPMyAdmin – with examples, I covered using phpMyAdmin’s visual interface to complete CREATE TABLE tasks. I also mentioned uploading CSV data files to a table using phpMyAdmin in an upcoming post. In this follow-up post, we accomplish uploading CSV files that both do and do not have the column names present in the first row. Continue reading to see the examples…
CSV to JSON with Python for MySQL upload
Admittedly, I have jumped head-first into the world of JSON within MySQL. I also have a thing for Python, of which I find myself using a lot of in my day job as Pipeline Survey Data Analyst. CSV’s are everywhere: in data at work, on the web, even in my personal life (as you’ll see). Loading CSV data into MySQL is nothing new to anyone working with either of the technologies. As a matter of fact, there are several ways you can get your CSV data into MySQL.
Consider making a donation as I continue to provide valuable content here on my blog. Thank you so much!!! Every bit is much appreciated and helps tremendously!
Thank you for reading this post. Please share it with someone else who would enjoy it as well.
Josh Otwell has a passion to grow as a PHP Developer, SQL expert, and technical blogger/writer.
Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like always, just because you can do something doesn’t mean you should. My opinions are my own.
Also have a look at MySQL Shell which has some fast tools to export and import data: https://dev.mysql.com/blog-archive/mysql-shell-dump-load-part-2-benchmarks/
https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-parallel-table.html
Thanks for the recommendation! Will do!