Convert JSON to SQL

Option 1 - Choose JSON file Encoding
Option 2 - Enter an URL
Option 3 - paste into Text Box below

  Examples:

Step 2: Choose output options

---

Output Options

Not working? If JSON variable A, name the array to convert:
Still not happy - try an alternative conversion

NOTE - you can change the column names below by overwriting the Field Name value.
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
Escape SQL Strings With Backslash (MySql style)

Include Auto Increment Clause on single numeric Primary Key using -- Choose -- MySQL AUTO_INCREMENT Sql Server IDENTITY(1,1) Access AUTOINCREMENT

For INSERT

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 ...)

For SELECT and MERGE

System TABLE needed to SELECT from? Table Name:
Batch how many rows together via UNION ALL? All 1 10 100 1000 Valid if not creating VIEW for SELECT