Warning: Undefined array key "mariadb" in /code/popular.php on line 39 Run, Practice, Share: Your Interactive SQL Playground - sqlize.online

SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular

INSERT INTO

Tags: MySQL 5.7 MySQL 5.7 Sakila (ReadOnly) MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) MariaDB 11.5 SQLite 3 SQLite 3 Preloaded PostgreSQL 10 Bookings (ReadOnly) PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 MS SQL Server 2022 AdventureWorks (ReadOnly) Firebird 4.0 Firebird 4.0 (Employee) Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free SOQOL

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