SQLize Online / PHPize Online

A A A
Share      Blog   Popular

INSERT INTO

Tags: MySQL 5.7 MySQL 8.0 MariaDB 10 SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 Oracle Database 19c Oracle Database 19c (HR) Oracle Database 21c

The INSERT INTO statement is used to insert new records in a table.

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); -- Most of DBMS supports multiple rows insrts INSERT INTO table_name ( column1, column2, column3, ... ) VALUES (value1, value2, value3, ...), (value1, value2, value3, ...), (value1, value2, value3, ...);

INSERT INTO - New snippets