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

977k

WHERE

540k

CREATE TABLE

410k

ORDER BY

398k

INSERT INTO

368k

JOIN

292k

PRIMARY KEY

258k

GROUP BY

250k

AND

245k

NOT

245k

199k

COUNT

188k

SHOW

155k

FOREIGN KEY

121k

WITH

116k

CONSTRAINT

105k

LEFT

94k

AUTO_INCREMENT

94k

DROP TABLE

92k

INNER JOIN

82k

73k

DEFAULT

72k

SUM

71k

LENGTH

61k

HAVING

55k

UPDATE

52k

38k

BETWEEN

38k

DELETE

33k

ALTER TABLE

30k

CASE

29k

CREATE VIEW

28k

CONCAT

28k

DROP VIEW

22k

MONTH

20k

ROW_NUMBER

20k

CREATE PROCEDURE

18k

EXEC

18k

REPLACE

16k

DROP PROCEDURE

15k

RIGHT

13k

ADD CONSTRAINT

10k

LEAD

DENSE_RANK

LAG

COALESCE

SUBSTRING

CROSS JOIN

OUTER JOIN

CREATE FUNCTION

CREATE OR REPLACE FUNCTION

INSERT INTO

TRUNCATE

ADD COLUMN

UPPER

LOWER

DROP COLUMN

SUBSTR

TRIM

DESCRIBE

INSERT INTO

DAYOFWEEK

CREATE OR REPLACE VIEW

CREATE OR REPLACE PROCEDURE

IFNULL

LEFT JOIN

REVERSE

JSON_CONTAINS

JSON_ARRAY

DROP CONSTRAINT

981

INSERT INTO

917

LPAD

855

INSERT INTO

779

UUID_GENERATE_V4

592

ORDER BY

527

INNER JOIN

497

JSON_AGG

456

NULLIF

447

INSERT INTO

384

CREATE OR REPLACE TRIGGER

360

GROUP BY

355

ADD CONSTRAINT

347

DROP FUNCTION

335

RTRIM

282

RPAD

246

LTRIM

205

PRIMARY KEY

151

DROP TRIGGER

121

ROW_TO_JSON

116

DROP INDEX

109

FOREIGN KEY

104

DROP SEQUENCE

DROP PROCEDURE

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, 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

SQLize Online / PHPize Online / SQLtest Online

INSERT INTO - Popular snippets

INSERT INTO - New snippets

SQLize.online - Popular functions