Run, Practice, Share: Your Interactive SQL Playground

INSERT INTO

Tags: MariaDB 11.4 MariaDB 11.5 MariaDB 10 MariaDB 10 Sakila (ReadOnly) MySQL 5.7 MySQL 5.7 Sakila (ReadOnly) MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) SQLite 3 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 - Popular snippets

MySQL 8.0 DROP TABLE CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT ORDER BY WHERE last run: 2024-05-14 21:13:24
5
SQLite 3 CREATE TABLE WITH SELECT CROSS JOIN ROW_NUMBER ORDER BY INSERT INTO last run: 2024-02-08 15:46:21
4
MS SQL Server 2017 CREATE TABLE WITH SELECT CROSS JOIN ROW_NUMBER ORDER BY INSERT INTO last run: 2024-02-08 15:45:34
3
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN last run: 2024-05-24 00:22:38
2
MySQL 8.0 DROP TABLE CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO last run: 2024-05-14 21:23:51
2
MySQL 8.0 DROP TABLE CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT ORDER BY WHERE IN last run: 2024-05-14 21:16:12
2
MySQL 8.0 DROP TABLE CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT ORDER BY WHERE IN last run: 2024-05-14 21:15:32
2
MySQL 8.0 DROP TABLE CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO last run: 2024-05-14 21:00:56
2
MS SQL Server 2019 AND IN COUNT CREATE TABLE NOT PRIMARY KEY WITH SELECT CASE CROSS JOIN INSERT INTO LOWER ORDER BY INNER JOIN WHERE OR EXEC INSERT INTO UPDATE DELETE LEFT ROW_NUMBER CONSTRAINT FOREIGN KEY GROUP BY LIKE OUTER JOIN BETWEEN last run: 2022-02-19 06:38:17
2
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN last run: 2024-05-29 11:54:26
1

INSERT INTO - New snippets

MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-29 11:54:26
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-29 11:53:47
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-24 00:21:54
2
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-22 22:53:17
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-22 22:53:03
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-22 22:51:53
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-22 22:51:33
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-22 22:51:02
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN JOIN added at: 2024-05-22 22:50:48
1
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO INSERT INTO SELECT INNER JOIN added at: 2024-05-22 22:48:38
1

SQLize.online - Popular functions

SELECT

767k

WHERE

425k

CREATE TABLE

383k

INSERT INTO

345k

ORDER BY

288k

PRIMARY KEY

240k

NOT

224k

JOIN

219k

AND

197k

GROUP BY

190k

144k

COUNT

143k

FOREIGN KEY

112k

SHOW

111k

WITH

100k

CONSTRAINT

97k

AUTO_INCREMENT

88k

DROP TABLE

85k

LEFT

76k

INNER JOIN

69k

DEFAULT

68k

63k

SUM

58k

UPDATE

47k

HAVING

43k

LENGTH

43k

33k

DELETE

32k

BETWEEN

31k

ALTER TABLE

27k

CREATE VIEW

26k

CASE

25k

CONCAT

21k

DROP VIEW

20k

MONTH

18k

ROW_NUMBER

17k

CREATE PROCEDURE

17k

EXEC

17k

DROP PROCEDURE

14k

REPLACE

11k

RIGHT

11k

ADD CONSTRAINT

LEAD

LAG

COALESCE

DENSE_RANK

CREATE FUNCTION

CROSS JOIN

INSERT INTO

SUBSTRING

CREATE OR REPLACE FUNCTION

OUTER JOIN

TRUNCATE

ADD COLUMN

UPPER

LOWER

DROP COLUMN

SUBSTR

TRIM

INSERT INTO

DESCRIBE

CREATE OR REPLACE VIEW

CREATE OR REPLACE PROCEDURE

IFNULL

DAYOFWEEK

REVERSE

JSON_CONTAINS

LEFT JOIN

970

INSERT INTO

849

DROP CONSTRAINT

830

JSON_ARRAY

778

INSERT INTO

772

LPAD

726

UUID_GENERATE_V4

584

ORDER BY

482

INNER JOIN

404

INSERT INTO

376

NULLIF

352

ADD CONSTRAINT

346

DROP FUNCTION

327

CREATE OR REPLACE TRIGGER

323

JSON_AGG

318

GROUP BY

284

RTRIM

278

LTRIM

204

RPAD

159

PRIMARY KEY

151

DROP TRIGGER

115

ROW_TO_JSON

113

FOREIGN KEY

104

DROP SEQUENCE

DROP PROCEDURE

DROP INDEX

CREATE TABLE

ADD COLUMN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

INNER JOIN

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 5.6, PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2.13
RDBMS versions: MariaDB 11.4, MariaDB 11.5, MariaDB 10, MariaDB 10 Sakila (ReadOnly), MySQL 5.7, MySQL 5.7 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), SQLite 3, 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

SQLize Online / PHPize Online / SQLtest Online

INSERT INTO - Popular snippets

INSERT INTO - New snippets

SQLize.online - Popular functions