SQLize - format run and share SQL queries online

Tags: MySQL 5.7 MySQL 5.7 (Sakila - ReadOnly) MySQL 8.0 MySQL 8.0 (Sakila - ReadOnly) MariaDB 10 MariaDB 10 (Sakila - ReadOnly) SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free SOQOL (beta)

ADD CONSTRAINT - Popular snippets

PostgreSQL 12 CREATE TABLE PRIMARY KEY DEFAULT ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT last run: 2022-11-27 18:41:35
28
MS SQL Server 2022 CREATE TABLE NOT COUNT INSERT INTO SELECT ALTER TABLE ADD CONSTRAINT PRIMARY KEY WHERE IN UPDATE CREATE PROCEDURE EXEC last run: 2023-07-25 14:06:19
20
MariaDB 10 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT INNER JOIN last run: 2023-04-17 11:16:41
14
MariaDB 10 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT INNER JOIN WHERE last run: 2023-11-27 09:00:50
11
PostgreSQL 12 CREATE TABLE PRIMARY KEY DEFAULT ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT WHERE AND OR JOIN INNER JOIN last run: 2023-03-23 20:16:09
10
PostgreSQL 14 CREATE TABLE ALTER TABLE ADD CONSTRAINT PRIMARY KEY SELECT UPDATE WHERE last run: 2023-09-22 19:31:49
9
MySQL 8.0 CREATE TABLE PRIMARY KEY ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT SUM INNER JOIN GROUP BY LEFT JOIN WHERE IN last run: 2023-12-06 06:56:23
9
MariaDB 10 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT INNER JOIN WHERE last run: 2023-08-06 07:07:41
9
MS SQL Server 2022 CREATE TABLE PRIMARY KEY ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT CONCAT WHERE AND BETWEEN IN LIKE NOT OR ORDER BY last run: 2023-12-02 14:09:03
8
PostgreSQL 12 CREATE TABLE PRIMARY KEY DEFAULT ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT INNER JOIN last run: 2022-11-24 02:06:39
8

ADD CONSTRAINT - New snippets

MySQL 5.7 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY DELETE ALTER TABLE ADD CONSTRAINT INSERT INTO added at: 2023-12-11 03:59:42
1
MySQL 5.7 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY DELETE ALTER TABLE ADD CONSTRAINT INSERT INTO added at: 2023-12-11 03:59:31
1
MySQL 5.7 CREATE TABLE NOT DEFAULT SELECT ALTER TABLE ADD CONSTRAINT PRIMARY KEY added at: 2023-12-10 09:38:54
1
MySQL 5.7 CREATE TABLE NOT DEFAULT SELECT ALTER TABLE ADD CONSTRAINT PRIMARY KEY added at: 2023-12-10 09:36:43
1
MySQL 5.7 CREATE TABLE NOT DEFAULT SELECT ALTER TABLE ADD CONSTRAINT PRIMARY KEY added at: 2023-12-10 09:35:50
1
MySQL 5.7 CREATE TABLE NOT DEFAULT SELECT ALTER TABLE ADD CONSTRAINT PRIMARY KEY added at: 2023-12-10 09:29:04
1
MS SQL Server 2022 CREATE TABLE PRIMARY KEY ALTER TABLE ADD CONSTRAINT FOREIGN KEY INSERT INTO SELECT WHERE AND GROUP BY HAVING IN COUNT added at: 2023-12-07 21:01:12
1
MySQL 5.7 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY DELETE DEFAULT ALTER TABLE ADD CONSTRAINT INSERT INTO UPDATE WHERE added at: 2023-12-06 20:54:41
1
MySQL 5.7 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY DELETE DEFAULT ALTER TABLE ADD CONSTRAINT INSERT INTO UPDATE WHERE added at: 2023-12-06 20:54:27
1
MySQL 5.7 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY DELETE DEFAULT ALTER TABLE ADD CONSTRAINT INSERT INTO UPDATE WHERE added at: 2023-12-06 20:48:33
2

SQLize.online - Popular functions

SELECT

288k

CREATE TABLE

284k

INSERT INTO

260k

WHERE

180k

PRIMARY KEY

174k

NOT

155k

AND

94k

FOREIGN KEY

82k

CONSTRAINT

77k

DROP TABLE

74k

JOIN

70k

GROUP BY

68k

AUTO_INCREMENT

64k

ORDER BY

62k

DEFAULT

57k

COUNT

57k

WITH

53k

INNER JOIN

39k

LEFT

38k

IN

32k

UPDATE

31k

SUM

28k

CREATE VIEW

23k

DELETE

23k

DROP VIEW

18k

ALTER TABLE

18k

HAVING

16k

LIKE

16k

OR

16k

BETWEEN

16k

CREATE PROCEDURE

14k

CASE

14k

DROP PROCEDURE

13k

MONTH

11k

EXEC

11k

ROW_NUMBER

10k

SHOW

7k

CONCAT

6k

RIGHT

6k

LAG

5k

ADD CONSTRAINT

5k

CREATE FUNCTION

4k

CREATE OR REPLACE FUNCTION

4k

COALESCE

4k

LEAD

4k

OUTER JOIN

3k

CROSS JOIN

3k

DENSE_RANK

2k

ADD COLUMN

2k

TRUNCATE

2k

INSERT INTO

2k

SUBSTRING

2k

LENGTH

2k

UPPER

2k

REPLACE

1k

TRIM

1k

LOWER

1k

DROP COLUMN

1k

CREATE OR REPLACE VIEW

1k

CREATE OR REPLACE PROCEDURE

1k

JSON_CONTAINS

951

SUBSTR

928

INSERT INTO

878

DESCRIBE

789

IFNULL

710

LEFT JOIN

548

INSERT INTO

471

REVERSE

418

INNER JOIN

381

JSON_ARRAY

379

DROP CONSTRAINT

334

UUID_GENERATE_V4

317

302

INSERT INTO

297

CREATE OR REPLACE TRIGGER

286

DROP FUNCTION

264

NULLIF

234

INSERT INTO

228

ORDER BY

207

RTRIM

203

LTRIM

172

LPAD

172

JSON_AGG

151

PRIMARY KEY

151

DAYOFWEEK

138

GROUP BY

118

DROP TRIGGER

97

76

FOREIGN KEY

68

RPAD

54

ADD COLUMN

51

46

CREATE OR REPLACE FUNCTION

46

ROW_TO_JSON

42

DROP INDEX

42

CREATE TABLE

41

DROP TABLE

38

DROP SEQUENCE

34

INSERT INTO

30

INSERT INTO

25

© 2023 SQLize - format run and share SQL queries online | About project | Disclaimer |

our telegram chat

VPS servers at the highest possible quality

PHP versions: PHP 5.6, PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2.3
RDBMS versions: MySQL 5.7, MySQL 5.7 (Sakila - ReadOnly), MySQL 8.0, MySQL 8.0 (Sakila - ReadOnly), MariaDB 10, MariaDB 10 (Sakila - ReadOnly), SQLite 3, PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL (beta)