Python 3 Script for Generating SQL Insert Statements from CSV Data

This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.

Importing a CSV into SQL Server Shouldn't Be This Hard

A frustrating time importing CSV files leads Steve to test the different options.

Get a CSV list of columns in a table

Short little script to get the columns in a table in order into a CSV format.

Can be useful for select or insert statements.