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 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 Oracle Database 11c Oracle Database 19c Oracle Database 19c Oracle Database 21c

CREATE OR REPLACE PROCEDURE - Popular snippets

PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN last run: 2022-07-09 06:27:04
3
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN last run: 2022-07-09 05:46:42
3
MS SQL Server 2017 CREATE OR REPLACE PROCEDURE INSERT INTO COUNT SELECT WHERE AND NOT last run: 2022-08-04 14:05:29
2
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN last run: 2022-07-09 06:20:43
2
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN last run: 2022-07-09 06:02:11
2
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY CREATE OR REPLACE PROCEDURE last run: 2022-07-09 04:28:32
2
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY INSERT INTO UPDATE WHERE SELECT AND DELETE IN ORDER BY COUNT INNER JOIN GROUP BY HAVING JOIN LAG CREATE VIEW CREATE OR REPLACE PROCEDURE EXEC last run: 2022-05-23 16:14:33
2
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY INSERT INTO UPDATE WHERE SELECT AND DELETE IN ORDER BY COUNT INNER JOIN GROUP BY HAVING JOIN LAG CREATE VIEW CREATE OR REPLACE PROCEDURE last run: 2022-05-23 15:55:04
2
MySQL 5.7 CREATE OR REPLACE PROCEDURE INSERT INTO COUNT SELECT WHERE AND NOT last run: 2022-08-04 14:05:16
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN last run: 2022-07-09 06:31:35
1

CREATE OR REPLACE PROCEDURE - New snippets

MS SQL Server 2017 CREATE OR REPLACE PROCEDURE INSERT INTO COUNT SELECT WHERE AND NOT added at: 2022-08-04 14:05:26
2
MySQL 5.7 CREATE OR REPLACE PROCEDURE INSERT INTO COUNT SELECT WHERE AND NOT added at: 2022-08-04 14:05:16
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:31:35
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:30:37
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:30:02
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:27:27
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:24:50
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:22:37
3
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:22:33
1
PostgreSQL 14 NOT CREATE TABLE PRIMARY KEY SUM INSERT INTO SELECT INNER JOIN WHERE CREATE VIEW UPDATE CASE IN AND GROUP BY ORDER BY CREATE OR REPLACE PROCEDURE ALTER TABLE ADD COLUMN added at: 2022-07-09 06:18:35
2

SQLize.online - Popular functions

CREATE TABLE

85k

SELECT

80k

INSERT INTO

76k

WHERE

44k

PRIMARY KEY

42k

NOT

31k

GROUP BY

22k

COUNT

21k

ORDER BY

20k

AND

20k

JOIN

19k

FOREIGN KEY

15k

UPDATE

14k

WITH

13k

AUTO_INCREMENT

11k

DELETE

10k

INNER JOIN

9k

LEFT

9k

IN

9k

SUM

9k

DEFAULT

8k

ALTER TABLE

7k

CONSTRAINT

7k

LIKE

6k

OR

5k

BETWEEN

5k

HAVING

5k

CASE

3k

ROW_NUMBER

3k

DROP TABLE

3k

SHOW

3k

CREATE VIEW

2k

MONTH

2k

CONCAT

2k

LAG

2k

RIGHT

2k

TRUNCATE

2k

EXEC

2k

OUTER JOIN

1k

COALESCE

1k

ADD COLUMN

1k

CREATE FUNCTION

1k

DENSE_RANK

1k

CROSS JOIN

845

SUBSTRING

835

LEAD

793

LENGTH

769

ADD CONSTRAINT

737

TRIM

709

CREATE OR REPLACE FUNCTION

556

DROP COLUMN

549

REPLACE

530

CREATE PROCEDURE

428

UPPER

404

LOWER

389

DESCRIBE

363

REVERSE

257

LEFT JOIN

226

SUBSTR

209

JSON_ARRAY

155

INSERT INTO

154

136

JSON_CONTAINS

135

IFNULL

131

LTRIM

99

DROP VIEW

99

JSON_AGG

90

DROP PROCEDURE

87

DROP CONSTRAINT

77

CREATE OR REPLACE PROCEDURE

72

INSERT INTO

60

GROUP BY

57

NULLIF

53

RTRIM

53

ORDER BY

51

ADD COLUMN

50

46

CREATE OR REPLACE FUNCTION

46

LPAD

42

DROP TABLE

38

INSERT INTO

29

DROP INDEX

28

CREATE OR REPLACE VIEW

25

INSERT INTO

24

CROSS JOIN

23

INSERT INTO

18

DROP FUNCTION

18

GROUP BY

17

UUID_GENERATE_V4

17

CREATE OR REPLACE FUNCTION

15

DROP SEQUENCE

15

13

ROW_TO_JSON

12

ORDER BY

12

DROP TRIGGER

12

INNER JOIN

10

INNER JOIN

9

FOREIGN KEY

8

7

RPAD

6

© 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.39, 8.0.30, MariaDB 10.8.3, PostgreSQL 11.16, 12.11, 13.7, 14.4, 15.beta Microsoft SQL Server 2017, 2019, SQLite 3, Oracle 21c, 19c (with predefined tables)