CSV — SQL Import/Export Compilation

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 almost 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…

--

--

--

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging. Sign-up for my free newsletter here: openlamptech.substack.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

You’re Still Doing Remote Work All Wrong

OOPs Concept in Python

How to serve react on Nginx over https

Kotlin Coroutines with Cloud DB

How I Got Python to Read My Emails

Get Started With Web Development: Self-Taught vs. Bootcamps vs. Getting a CS Degree

Human confused about which direction to take when learning how to code

Using OpenCV to Catoonize an Image

What does swappiness do and how does it affect swap_tendency?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Joshua Otwell

Joshua Otwell

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging. Sign-up for my free newsletter here: openlamptech.substack.com

More from Medium

What is PL/SQL? Why use PL/SQL over SQL.

Quick SQL Snippets in MySQL Workbench

Embedded SQL and Dynamic SQL a

To import spreadsheet or excel data into a db file in SQLite format