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

NOT - Popular snippets

MariaDB 10 CREATE TABLE NOT INSERT INTO SELECT SUM INNER JOIN WHERE last run: 2022-01-12 16:36:41
9
MySQL 8.0 CREATE TABLE NOT INSERT INTO AND WITH SELECT WHERE SUM IN COUNT ORDER BY BETWEEN LEFT JOIN GROUP BY last run: 2022-01-12 09:51:19
6
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY INSERT INTO last run: 2022-01-14 19:17:11
5
PostgreSQL 13 CREATE TABLE NOT PRIMARY KEY INSERT INTO CREATE FUNCTION IN SELECT ORDER BY WHERE AND last run: 2022-01-14 15:56:11
5
MySQL 8.0 CREATE TABLE PRIMARY KEY NOT INSERT INTO SELECT UPDATE DELETE last run: 2022-01-15 18:35:30
4
PostgreSQL 13 CREATE TABLE NOT PRIMARY KEY INSERT INTO CREATE FUNCTION IN SELECT ORDER BY WHERE AND last run: 2022-01-14 09:41:55
4
PostgreSQL 13 CREATE TABLE NOT PRIMARY KEY INSERT INTO CREATE FUNCTION IN SELECT ORDER BY WHERE AND last run: 2022-01-14 09:36:35
4
MS SQL Server 2017 CREATE TABLE NOT PRIMARY KEY INSERT INTO IN WITH AND SELECT INNER JOIN last run: 2022-01-14 09:09:23
4
MS SQL Server 2017 CREATE TABLE NOT PRIMARY KEY INSERT INTO IN WITH AND SELECT GROUP BY HAVING INNER JOIN last run: 2022-01-14 07:51:18
4
MySQL 5.7 CREATE TABLE NOT last run: 2022-01-13 23:03:12
4

NOT - New snippets

MySQL 8.0 CREATE TABLE DELETE NOT PRIMARY KEY AND added at: 2022-01-16 17:46:39
1
MySQL 8.0 CREATE TABLE DELETE NOT PRIMARY KEY AND added at: 2022-01-16 17:46:23
1
MySQL 8.0 CREATE TABLE DELETE NOT AND PRIMARY KEY added at: 2022-01-16 17:45:55
1
MySQL 8.0 CREATE TABLE NOT added at: 2022-01-16 17:45:06
2
MySQL 8.0 CREATE TABLE NOT CONSTRAINT AND added at: 2022-01-16 17:44:59
1
MySQL 8.0 CREATE TABLE DELETE NOT PRIMARY KEY CONSTRAINT added at: 2022-01-16 17:44:40
1
MS SQL Server 2017 CREATE TABLE INSERT INTO SELECT NOT WHERE added at: 2022-01-16 17:42:25
1
MS SQL Server 2017 CREATE TABLE INSERT INTO SELECT NOT WHERE added at: 2022-01-16 17:42:14
1
MS SQL Server 2017 CREATE TABLE INSERT INTO SELECT NOT WHERE added at: 2022-01-16 17:42:07
1
MS SQL Server 2017 CREATE TABLE INSERT INTO SELECT NOT WHERE added at: 2022-01-16 17:41:56
1

SQLize.online - Popular functions

CREATE TABLE

12k

INSERT INTO

10k

SELECT

10k

PRIMARY KEY

8k

WHERE

6k

COUNT

3k

GROUP BY

3k

FOREIGN KEY

3k

JOIN

3k

ORDER BY

2k

UPDATE

2k

WITH

2k

AUTO_INCREMENT

2k

DELETE

1k

INNER JOIN

1k

ALTER TABLE

1k

SUM

1k

CONSTRAINT

926

LEFT

864

NOT

777

OUTER JOIN

468

AND

465

CREATE VIEW

309

IN

281

EXEC

276

CASE

268

ADD COLUMN

253

SHOW

243

ROW_NUMBER

241

ADD CONSTRAINT

207

LEFT JOIN

202

CREATE FUNCTION

201

CROSS JOIN

169

MONTH

167

COALESCE

161

HAVING

149

LENGTH

127

BETWEEN

108

LIKE

107

CONCAT

102

REPLACE

98

OR

98

RIGHT

97

INSERT INTO

72

UPPER

57

SUBSTRING

45

SUBSTR

40

32

INSERT INTO

24

TRIM

21

REVERSE

16

IFNULL

15

TRUNCATE

12

LOWER

9

ADD COLUMN

7

NULLIF

3

INSERT INTO

3

RANDOM()

2

@@VERSION

1

GENERATE_SERIES

1

LEFT OUTER JOIN

1

REPLACE()

1

SQLITE_VERSION()

1

STRING_AGG

1

SUBSPRING

1

UPADTE

1

VERSION()

1

1

ORDER BY

1

© 2022 SQLize - format run and share SQL queries online | About project | Disclaimer | PHP versions: 5.6.40, 7.4.14, 8.0.1 | 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