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

TRIM - Popular snippets

MS SQL Server 2019 CREATE TABLE PRIMARY KEY INSERT INTO TRIM WITH EXEC COUNT SELECT last run: 2021-12-31 16:19:46
2
MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT last run: 2021-12-11 16:56:55
2
MS SQL Server 2019 CREATE TABLE PRIMARY KEY INSERT INTO TRIM WITH EXEC COUNT last run: 2021-12-31 14:04:04
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT last run: 2021-12-12 17:16:27
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE last run: 2021-12-12 17:14:55
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE last run: 2021-12-12 17:13:39
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM last run: 2021-12-12 17:12:52
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT last run: 2021-12-12 14:31:50
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT last run: 2021-12-12 14:29:55
1
MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT last run: 2021-12-11 16:57:18
1

TRIM - New snippets

MS SQL Server 2019 CREATE TABLE PRIMARY KEY INSERT INTO TRIM WITH EXEC COUNT SELECT added at: 2021-12-31 14:05:17
2
MS SQL Server 2019 CREATE TABLE PRIMARY KEY INSERT INTO TRIM WITH EXEC COUNT added at: 2021-12-31 14:04:04
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT added at: 2021-12-12 17:16:27
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE added at: 2021-12-12 17:14:55
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE added at: 2021-12-12 17:13:39
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM added at: 2021-12-12 17:12:52
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT added at: 2021-12-12 14:31:50
1
MS SQL Server 2017 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT added at: 2021-12-12 14:29:55
1
MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT added at: 2021-12-11 16:57:18
1
MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRIM WHERE CASE COUNT added at: 2021-12-11 16:56:14
2

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

865

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