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

UPPER - Popular snippets

MySQL 5.7 CREATE TABLE INSERT INTO WITH UPPER SELECT WHERE last run: 2021-12-02 11:52:17
3
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER last run: 2021-12-16 14:12:49
2
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT UPPER WHERE last run: 2021-12-11 21:57:39
2
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT UPPER WHERE last run: 2021-12-11 21:52:22
2
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT UPPER ORDER BY last run: 2021-12-11 21:43:57
2
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT UPPER ORDER BY last run: 2021-12-11 21:42:13
2
MS SQL Server 2017 CREATE TABLE CONSTRAINT PRIMARY KEY INSERT INTO COUNT SUM WITH UPPER REPLACE EXEC ALTER TABLE ADD CONSTRAINT FOREIGN KEY last run: 2021-12-18 20:27:57
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER last run: 2021-12-16 14:29:09
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER last run: 2021-12-16 14:29:00
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER last run: 2021-12-16 14:28:08
1

UPPER - New snippets

MS SQL Server 2017 CREATE TABLE CONSTRAINT PRIMARY KEY INSERT INTO COUNT SUM WITH UPPER REPLACE EXEC ALTER TABLE ADD CONSTRAINT FOREIGN KEY added at: 2021-12-18 20:27:57
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:29:09
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:29:00
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:28:08
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:16:52
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:16:09
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:15:01
1
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:11:19
2
PostgreSQL 13 CREATE TABLE INSERT INTO WITH SELECT COUNT GROUP BY WHERE UPPER added at: 2021-12-16 14:10:22
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT UPPER WHERE CASE COUNT added at: 2021-12-11 22:25:37
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

464

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