Convert CSV to SQL

INSERT, UPDATE, DELETE, MERGE, and SELECT statements can be created.
CREATE TABLE, DROP TABLE, CREATE VIEW, DROP VIEW are optional.
The key used in UPDATE, DELETE, and MERGE is specified by setting the key column.
Now it is easy to merge csv into a database table by using the new Generate MERGE feature.
A field value may be trimmed, made uppercase, or lowercase. You can add custom text around the field value by using the template feature. For example, if you are using Oracle and want to convert a field in YYYYMMDD format to DATE, use TO_DATE({f},'YYYYMMDD'). Likewise for Sql Server, use CAST({f} AS DATETIME). The field value will be substituted for {f}.
Current version supports some database specific output and support ORACLE, MYSQL, SQL SERVER, PostreSQL and ANSI SQL databases. There are slight variations in the way different databases handle NULLs, empty strings, DATES, etc. .

You can specify which fields to include and specify the name of the field.
You can choose to quote your column names as appropriate for your database engine.
You can sort the output by column name.
You can use NULL for empty fields.

Output Options

Keep original field names as column names

NOTE - you can change the column names below by overwriting the Field Name value.

Replace spaces with underscores in field names

Enclose field names below with Quotes ("name") Backtick (`name`) Brackets ([name])

Schema.Table or View Name:

Drop Table/View IF EXISTS

Create Table/View IF NOT EXISTS

Include Auto Increment Clause on single numeric Primary Key using

Use REPLACE instead (REPLACE INTO tablename ....)

Use one INSERT/REPLACE statement with multiple VALUES clauses - How many?

Add phrase after INSERT/UPDATE keyword: (INSERT phrase INTO ...) System TABLE needed to SELECT from? Table Name:

Batch how many rows together via UNION ALL? Valid if not creating VIEW for SELECT Escape SQL Strings With Backslash (MySql style)

NULL value: A field value of NULL in CSV to be NULL in SQL

Output Format for Dates Uses standard SQL formatting

Choose Conversion Type:

Result Data:

Save your result:.sqlEOL:

You can Save the complete data and settings, and then later Load them from your saved file.
Load Saved Form
Save Form (data and settings)