Run, Practice, Share: Your Interactive SQL Playground

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

ADD COLUMN - Popular snippets

PostgreSQL 14 CREATE TABLE PRIMARY KEY AND ADD COLUMN ALTER TABLE SELECT last run: 2024-07-26 12:34:46
25
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO SELECT ALTER TABLE ADD COLUMN EXEC IN last run: 2023-06-19 05:52:49
23
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY INSERT INTO WITH SELECT WHERE JOIN DROP TABLE ALTER TABLE ADD COLUMN UPDATE DROP COLUMN DELETE ORDER BY last run: 2023-07-05 22:39:04
11
PostgreSQL 14 CREATE TABLE SELECT WHERE INSERT INTO DELETE ALTER TABLE ADD COLUMN UPDATE last run: 2022-02-15 15:22:23
11
MySQL 8.0 CREATE TABLE INSERT INTO ALTER TABLE ADD COLUMN SELECT last run: 2024-06-21 19:28:28
8
PostgreSQL 14 DROP TABLE CREATE TABLE NOT PRIMARY KEY FOREIGN KEY INSERT INTO WITH SELECT AND UPDATE ALTER TABLE ADD COLUMN DEFAULT WHERE LIKE IN last run: 2024-08-21 14:22:37
8
PostgreSQL 14 CREATE TABLE SELECT WHERE INSERT INTO DELETE ALTER TABLE ADD COLUMN UPDATE last run: 2022-02-15 15:15:20
7
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT INSERT INTO ALTER TABLE ADD COLUMN SELECT last run: 2024-02-19 08:56:47
6
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO SELECT ALTER TABLE ADD COLUMN last run: 2024-01-20 01:57:55
6
Oracle Database 21c CREATE TABLE DESCRIBE INSERT INTO SELECT UPDATE WHERE ADD COLUMN ALTER TABLE COUNT INNER JOIN RIGHT JOIN LEFT last run: 2023-07-17 12:41:51
6

ADD COLUMN - New snippets

MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN FOREIGN KEY UPDATE added at: 2024-09-09 05:56:06
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN FOREIGN KEY UPDATE added at: 2024-09-09 05:55:56
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN FOREIGN KEY UPDATE DESCRIBE added at: 2024-09-09 05:55:34
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN FOREIGN KEY UPDATE DESCRIBE added at: 2024-09-09 05:55:26
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN FOREIGN KEY UPDATE added at: 2024-09-09 05:54:49
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN FOREIGN KEY UPDATE added at: 2024-09-09 05:54:41
2
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN DEFAULT FOREIGN KEY added at: 2024-09-09 05:53:35
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN DEFAULT FOREIGN KEY added at: 2024-09-09 05:53:33
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN DEFAULT FOREIGN KEY DESCRIBE added at: 2024-09-09 05:53:21
1
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT AUTO_INCREMENT PRIMARY KEY ALTER TABLE ADD COLUMN NOT FOREIGN KEY DESCRIBE added at: 2024-09-09 05:52:54
1

SQLize.online - Popular functions

SELECT

686k

WHERE

383k

CREATE TABLE

375k

INSERT INTO

337k

ORDER BY

247k

PRIMARY KEY

235k

NOT

217k

JOIN

196k

AND

182k

GROUP BY

172k

COUNT

131k

123k

FOREIGN KEY

111k

CONSTRAINT

95k

SHOW

94k

WITH

94k

AUTO_INCREMENT

86k

DROP TABLE

83k

LEFT

71k

DEFAULT

67k

INNER JOIN

65k

60k

SUM

55k

UPDATE

46k

HAVING

39k

LENGTH

34k

DELETE

32k

30k

BETWEEN

30k

ALTER TABLE

27k

CREATE VIEW

26k

CASE

24k

DROP VIEW

20k

CONCAT

19k

CREATE PROCEDURE

17k

EXEC

17k

MONTH

17k

ROW_NUMBER

17k

DROP PROCEDURE

14k

RIGHT

10k

REPLACE

ADD CONSTRAINT

LAG

COALESCE

LEAD

DENSE_RANK

CREATE FUNCTION

INSERT INTO

CREATE OR REPLACE FUNCTION

CROSS JOIN

SUBSTRING

OUTER JOIN

TRUNCATE

ADD COLUMN

UPPER

LOWER

DROP COLUMN

TRIM

SUBSTR

INSERT INTO

CREATE OR REPLACE VIEW

CREATE OR REPLACE PROCEDURE

DESCRIBE

IFNULL

JSON_CONTAINS

REVERSE

DAYOFWEEK

934

LEFT JOIN

929

INSERT INTO

849

DROP CONSTRAINT

830

INSERT INTO

772

JSON_ARRAY

741

LPAD

665

UUID_GENERATE_V4

584

ORDER BY

468

INNER JOIN

404

INSERT INTO

366

ADD CONSTRAINT

346

NULLIF

333

DROP FUNCTION

327

CREATE OR REPLACE TRIGGER

318

GROUP BY

283

JSON_AGG

279

RTRIM

253

LTRIM

203

PRIMARY KEY

151

DROP TRIGGER

115

FOREIGN KEY

104

ROW_TO_JSON

101

RPAD

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

ADD COLUMN - Popular snippets

ADD COLUMN - New snippets

SQLize.online - Popular functions