SQLize - format run and share SQL queries online

Tags: MySQL 5.7 MySQL 8.0 MariaDB 10 SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 MS SQL Server 2017 MS SQL Server 2019

INSERT INTO - Popular snippets

MySQL 5.7 CREATE TABLE PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT JOIN COALESCE GROUP BY ORDER BY last run: 2022-01-21 20:20:02
13
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY last run: 2022-01-19 11:38:23
5
MySQL 5.7 CREATE TABLE PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT JOIN COALESCE GROUP BY ORDER BY last run: 2022-01-10 16:17:01
4
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE WHERE GROUP BY ORDER BY last run: 2022-01-19 13:01:20
3
MySQL 5.7 CREATE TABLE PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT JOIN COALESCE GROUP BY ORDER BY last run: 2022-01-15 09:49:19
3
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY WHERE last run: 2022-01-19 11:47:16
2
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT COALESCE JOIN GROUP BY ORDER BY last run: 2022-01-15 09:21:37
2
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT JOIN COALESCE GROUP BY ORDER BY last run: 2022-01-18 19:05:54
2
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT JOIN COALESCE GROUP BY ORDER BY last run: 2022-01-18 19:52:36
2
MySQL 5.7 CREATE TABLE PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT COALESCE JOIN GROUP BY ORDER BY last run: 2021-11-23 12:43:22
2

INSERT INTO - New snippets

MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE WHERE GROUP BY ORDER BY added at: 2022-01-19 11:57:20
3
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE WHERE GROUP BY ORDER BY AND added at: 2022-01-19 11:56:52
1
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE WHERE GROUP BY ORDER BY AND added at: 2022-01-19 11:56:35
1
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY WHERE AND added at: 2022-01-19 11:55:52
1
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY WHERE AND added at: 2022-01-19 11:55:29
1
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY WHERE added at: 2022-01-19 11:53:07
1
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY WHERE added at: 2022-01-19 11:46:45
1
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY WHERE added at: 2022-01-19 11:45:03
2
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT LEFT JOIN COALESCE GROUP BY ORDER BY added at: 2022-01-19 11:44:37
1
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY DELETE UPDATE INSERT INTO INSERT INTO SELECT COALESCE LEFT JOIN GROUP BY ORDER BY added at: 2022-01-19 09:32:29
1

SQLize.online - Popular functions

CREATE TABLE

55k

SELECT

48k

INSERT INTO

48k

WHERE

28k

PRIMARY KEY

26k

NOT

18k

GROUP BY

14k

COUNT

14k

ORDER BY

12k

JOIN

12k

AND

12k

FOREIGN KEY

10k

UPDATE

8k

WITH

8k

AUTO_INCREMENT

7k

DELETE

6k

IN

6k

SUM

6k

LEFT

6k

INNER JOIN

5k

ALTER TABLE

5k

LIKE

4k

OR

3k

BETWEEN

3k

CONSTRAINT

3k

DEFAULT

3k

HAVING

3k

CASE

2k

SHOW

2k

ROW_NUMBER

1k

TRUNCATE

1k

LAG

1k

MONTH

1k

CONCAT

1k

OUTER JOIN

1k

CREATE VIEW

991

DROP TABLE

920

ADD COLUMN

919

EXEC

892

CREATE FUNCTION

733

TRIM

692

DENSE_RANK

673

RIGHT

663

COALESCE

557

ADD CONSTRAINT

507

DROP COLUMN

482

CROSS JOIN

447

LEAD

423

SUBSTRING

415

LENGTH

398

REPLACE

375

LOWER

279

UPPER

274

CREATE OR REPLACE FUNCTION

234

LEFT JOIN

225

SUBSTR

185

DESCRIBE

166

REVERSE

118

INSERT INTO

112

IFNULL

98

JSON_ARRAY

86

DROP CONSTRAINT

73

71

INSERT INTO

59

CREATE PROCEDURE

52

RTRIM

51

ADD COLUMN

50

LPAD

42

JSON_AGG

40

39

ORDER BY

37

INSERT INTO

29

JSON_CONTAINS

27

INSERT INTO

24

CROSS JOIN

23

DROP PROCEDURE

21

DROP INDEX

21

NULLIF

20

INSERT INTO

17

GROUP BY

17

DROP TABLE

13

CREATE OR REPLACE VIEW

13

ROW_TO_JSON

12

ORDER BY

12

DROP VIEW

10

CREATE OR REPLACE FUNCTION

9

INNER JOIN

9

LTRIM

8

UUID_GENERATE_V4

7

CREATE TABLE

4

DROP TRIGGER

4

INSERT INTO

3

RIGTH JOIN

3

DROP FUNCTION

3

CREATE OR REPLACE FUNCTION

3

RANDOM()

2

CROSS JOIN

2

CREATE OR REPLACE VIEW

2

CROSS JOIN

2

@@VERSION

1

© 2022 SQLize - format run and share SQL queries online | About project | Disclaimer
PHP versions: 5.6.40, 7.4.14, 8.0.1, 8.1.5 | RDBMS versions: MySQL 5.7.33, 8.0.23, MariaDB 10.5.9, PostgreSQL 11.9, 12.4, 13.2, 14.0, Microsoft SQL Server 2017, 2019, SQLite 3