INSERT INTO

SQL standard specifies the following CREATE TABLE syntax:

INSERT INTO table_name

All dialects (except Hive) suppurt this syntax, plus a bunch of extra stuff:

BigQuery:

INSERT INTO table_name

DB2:

INSERT INTO table_name

Hive:

INSERT INTO TABLE table_name

MariaDB:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] table_name

REPLACE [LOW_PRIORITY | DELAYED] [INTO] table_name

MySQL:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] table_name

REPLACE [LOW_PRIORITY | DELAYED] [INTO] table_name

N1QL:

INSERT INTO table_name

PL/SQL:

INSERT [hint] [ALL] INTO

PostgreSQL:

INSERT INTO table_name

Redshift:

INSERT INTO table_name

Spark:

INSERT [INTO | OVERWRITE] [TABLE] table_name

SQLite:

INSERT [OR {ABORT | FAIL | IGNORE | REPLACE | ROLLBACK}] INTO table_name

REPLACE INTO table_name

Transact-SQL:

INSERT [TOP ( expression ) [PERCENT]] [INTO] table_name

Trino:

INSERT INTO table_name