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

DROP VIEW - Popular snippets

MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW LEFT JOIN LIKE DROP PROCEDURE CREATE PROCEDURE INNER JOIN last run: 2022-10-03 13:50:22
5
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE WITH COUNT GROUP BY LEFT JOIN last run: 2022-10-01 16:56:33
4
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE WITH COUNT GROUP BY LEFT JOIN last run: 2022-10-01 15:19:41
4
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND DROP VIEW CREATE VIEW LEFT JOIN LIKE DROP PROCEDURE CREATE PROCEDURE INNER JOIN WITH COUNT GROUP BY last run: 2022-09-17 02:50:50
4
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE last run: 2022-10-03 16:23:53
3
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE last run: 2022-10-03 14:09:11
3
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW LEFT JOIN LIKE DROP PROCEDURE CREATE PROCEDURE INNER JOIN last run: 2022-10-03 05:29:09
3
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT CONSTRAINT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE AND DROP VIEW CREATE VIEW COUNT LEFT JOIN LIKE GROUP BY last run: 2022-10-02 11:13:46
3
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE COUNT GROUP BY last run: 2022-09-30 11:37:46
3
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE COUNT GROUP BY last run: 2022-09-30 11:02:37
3

DROP VIEW - New snippets

MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE added at: 2022-10-03 16:51:52
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE added at: 2022-10-03 16:49:26
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:37:55
1
MariaDB 10 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:37:25
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:32:36
2
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:23:25
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:21:04
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:13:47
3
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:11:42
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY INSERT INTO DEFAULT SELECT WHERE CONSTRAINT AND DROP VIEW CREATE VIEW INNER JOIN LIKE DROP PROCEDURE CREATE PROCEDURE added at: 2022-10-03 16:10:02
1

SQLize.online - Popular functions

CREATE TABLE

88k

SELECT

83k

INSERT INTO

79k

WHERE

46k

PRIMARY KEY

45k

NOT

33k

GROUP BY

22k

AND

22k

COUNT

21k

ORDER BY

21k

JOIN

19k

FOREIGN KEY

17k

UPDATE

14k

WITH

13k

AUTO_INCREMENT

12k

DELETE

10k

INNER JOIN

10k

LEFT

10k

IN

10k

DEFAULT

9k

SUM

9k

CONSTRAINT

9k

ALTER TABLE

7k

LIKE

6k

OR

5k

BETWEEN

5k

HAVING

5k

DROP TABLE

4k

CASE

3k

CREATE VIEW

3k

ROW_NUMBER

3k

SHOW

3k

CONCAT

2k

MONTH

2k

LAG

2k

EXEC

2k

RIGHT

2k

TRUNCATE

2k

OUTER JOIN

1k

COALESCE

1k

ADD COLUMN

1k

CREATE FUNCTION

1k

DENSE_RANK

1k

CROSS JOIN

845

LENGTH

837

SUBSTRING

835

LEAD

814

CREATE PROCEDURE

780

ADD CONSTRAINT

740

TRIM

709

CREATE OR REPLACE FUNCTION

589

LOWER

562

DROP COLUMN

560

DROP VIEW

534

REPLACE

533

DROP PROCEDURE

439

UPPER

437

DESCRIBE

394

INSERT INTO

302

REVERSE

257

LEFT JOIN

226

SUBSTR

209

JSON_ARRAY

155

INSERT INTO

154

136

JSON_CONTAINS

135

IFNULL

131

LTRIM

99

JSON_AGG

90

DROP CONSTRAINT

77

CREATE OR REPLACE PROCEDURE

73

GROUP BY

57

NULLIF

53

RTRIM

53

ORDER BY

51

ADD COLUMN

50

46

CREATE OR REPLACE FUNCTION

46

LPAD

42

CREATE OR REPLACE VIEW

40

DROP TABLE

38

INSERT INTO

30

DROP INDEX

28

INSERT INTO

24

CROSS JOIN

23

INSERT INTO

18

DROP FUNCTION

18

CREATE OR REPLACE FUNCTION

17

GROUP BY

17

UUID_GENERATE_V4

17

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)