Run, Practice, Share: Your Interactive SQL Playground

Tags: MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) MySQL 9.3.0 MariaDB 11.4 MariaDB 11.8 MariaDB 10 MariaDB 10 Sakila (ReadOnly) SQLite 3 SQLite 3 Preloaded PostgreSQL 10 Bookings (ReadOnly) PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 PostgreSQL 16 PostgreSQL 17 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

Popular snippets

MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-06-18 07:10:47
5942
MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-06-17 21:24:22
5069
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-06-18 08:00:51
4999
SELECT VERSION() last run: 2025-01-31 15:44:21
4832
MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-06-18 06:12:28
2873
MySQL 8.0 SELECT VERSION() last run: 2025-06-18 07:02:47
2597
MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-06-18 08:03:44
2580
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-06-18 08:01:38
2546
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-06-18 07:22:11
2244
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-06-17 19:52:51
2230

New snippets

MySQL 8.0 CREATE TABLE SELECT ALTER TABLE ADD COLUMN PRIMARY KEY INSERT INTO added at: 2025-06-18 08:16:34
1
MySQL 8.0 CREATE TABLE PRIMARY KEY NOT added at: 2025-06-18 08:16:33
1
MySQL 8.0 CREATE TABLE PRIMARY KEY NOT SELECT INSERT INTO added at: 2025-06-18 08:16:17
1
MySQL 8.0 CREATE TABLE PRIMARY KEY NOT added at: 2025-06-18 08:16:12
1
MySQL 8.0 Sakila (ReadOnly) SELECT WHERE ORDER BY SHOW LIKE added at: 2025-06-18 08:15:38
1
MySQL 8.0 CREATE TABLE PRIMARY KEY SELECT INSERT INTO added at: 2025-06-18 08:15:35
1
MySQL 8.0 Sakila (ReadOnly) SELECT WHERE ORDER BY added at: 2025-06-18 08:15:27
1
MySQL 8.0 CREATE TABLE PRIMARY KEY NOT SELECT INSERT INTO added at: 2025-06-18 08:15:20
3
MySQL 8.0 Sakila (ReadOnly) SELECT INNER JOIN ORDER BY SHOW LIKE added at: 2025-06-18 08:15:09
1
MySQL 8.0 Sakila (ReadOnly) SELECT INNER JOIN ORDER BY added at: 2025-06-18 08:15:02
2

SQLize.online - Popular functions

SELECT

1671k

WHERE

917k

ORDER BY

765k

JOIN

532k

CREATE TABLE

501k

INSERT INTO

446k

GROUP BY

439k

AND

400k

381k

NOT

327k

PRIMARY KEY

323k

COUNT

309k

SHOW

297k

WITH

175k

FOREIGN KEY

156k

LEFT

155k

CONSTRAINT

133k

LENGTH

127k

INNER JOIN

119k

AUTO_INCREMENT

117k

DROP TABLE

117k

111k

SUM

110k

HAVING

92k

DEFAULT

90k

UPDATE

74k

68k

BETWEEN

59k

CONCAT

48k

DELETE

43k

CASE

40k

ALTER TABLE

38k

CREATE VIEW

37k

REPLACE

29k

DROP VIEW

27k

ROW_NUMBER

26k

MONTH

25k

CREATE PROCEDURE

23k

EXEC

20k

RIGHT

19k

DROP PROCEDURE

19k

DENSE_RANK

14k

ADD CONSTRAINT

13k

LEAD

12k

COALESCE

12k

SUBSTRING

11k

LAG

10k

CROSS JOIN

10k

OUTER JOIN

CREATE OR REPLACE FUNCTION

CREATE FUNCTION

INSERT INTO

ADD COLUMN

TRUNCATE

DAYOFWEEK

UPPER

LOWER

SUBSTR

DROP COLUMN

DESCRIBE

TRIM

IFNULL

INSERT INTO

LEFT JOIN

REVERSE

CREATE OR REPLACE VIEW

CREATE OR REPLACE PROCEDURE

JSON_ARRAY

JSON_CONTAINS

LPAD

DROP CONSTRAINT

INSERT INTO

NULLIF

875

INSERT INTO

855

ORDER BY

779

JSON_AGG

723

UUID_GENERATE_V4

633

INNER JOIN

535

INSERT INTO

469

CREATE OR REPLACE TRIGGER

445

GROUP BY

437

RTRIM

416

ADD CONSTRAINT

413

DROP FUNCTION

377

DROP INDEX

312

LTRIM

293

RPAD

264

DROP TRIGGER

202

FOREIGN KEY

178

PRIMARY KEY

153

CREATE TABLE

150

ROW_TO_JSON

143

DROP SEQUENCE

DROP PROCEDURE

ADD COLUMN

INNER JOIN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MySQL 9.3.0, MariaDB 11.4, MariaDB 11.8, MariaDB 10, MariaDB 10 Sakila (ReadOnly), SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, 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

Popular snippets

New snippets

SQLize.online - Popular functions