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 MS SQL Server 2022 Oracle Database 19c Oracle Database 19c (HR) Oracle Database 21c

DROP VIEW - Popular snippets

SQLite 3 DROP VIEW CREATE VIEW SELECT LEFT JOIN last run: 2022-12-22 15:14:57
15
MySQL 5.7 DROP VIEW CREATE VIEW SELECT LEFT JOIN last run: 2022-12-28 04:50:07
12
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND UPDATE DROP VIEW CREATE VIEW LEFT JOIN INNER JOIN DROP PROCEDURE CREATE PROCEDURE WITH COUNT GROUP BY last run: 2022-10-29 05:23:25
11
MariaDB 10 DROP VIEW CREATE VIEW SELECT LEFT JOIN last run: 2022-12-10 09:28:05
10
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-10-20 19:05:36
10
MySQL 5.7 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW LEFT JOIN LIKE INNER JOIN DROP PROCEDURE CREATE PROCEDURE last run: 2022-12-29 04:39:41
9
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE WITH COUNT RIGHT JOIN GROUP BY LEFT last run: 2022-10-27 21:39:07
9
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE last run: 2022-10-27 05:34:59
9
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 LEFT JOIN last run: 2022-10-05 04:23:07
9
MariaDB 10 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN LEFT JOIN DROP PROCEDURE CREATE PROCEDURE last run: 2022-11-29 19:24:09
8

DROP VIEW - New snippets

MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE LEFT JOIN WITH COUNT GROUP BY added at: 2023-02-05 14:33:25
2
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW INNER JOIN DROP PROCEDURE CREATE PROCEDURE LEFT JOIN WITH COUNT GROUP BY added at: 2023-02-05 14:32:19
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN DROP PROCEDURE CREATE PROCEDURE added at: 2023-02-05 14:30:00
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN DROP PROCEDURE CREATE PROCEDURE added at: 2023-02-05 14:29:39
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN added at: 2023-02-05 14:28:52
4
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN added at: 2023-02-05 14:28:10
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN added at: 2023-02-05 14:27:26
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN added at: 2023-02-05 14:26:43
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN added at: 2023-02-05 14:26:25
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE AND DROP VIEW CREATE VIEW WITH COUNT LEFT JOIN GROUP BY INNER JOIN added at: 2023-02-05 14:26:20
1

SQLize.online - Popular functions

CREATE TABLE

154k

SELECT

151k

INSERT INTO

141k

WHERE

94k

PRIMARY KEY

93k

NOT

77k

AND

47k

FOREIGN KEY

42k

CONSTRAINT

41k

JOIN

37k

GROUP BY

37k

COUNT

35k

DROP TABLE

35k

AUTO_INCREMENT

35k

DEFAULT

31k

ORDER BY

30k

WITH

25k

INNER JOIN

23k

LEFT

21k

UPDATE

18k

IN

15k

SUM

14k

CREATE VIEW

13k

DELETE

12k

ALTER TABLE

11k

DROP VIEW

10k

BETWEEN

9k

LIKE

9k

OR

8k

CREATE PROCEDURE

8k

DROP PROCEDURE

7k

HAVING

7k

CASE

5k

ROW_NUMBER

5k

EXEC

4k

SHOW

4k

RIGHT

4k

CONCAT

3k

MONTH

3k

ADD CONSTRAINT

3k

LAG

3k

CREATE FUNCTION

3k

CREATE OR REPLACE FUNCTION

2k

COALESCE

2k

OUTER JOIN

2k

LEAD

2k

TRUNCATE

2k

ADD COLUMN

2k

DENSE_RANK

1k

CROSS JOIN

1k

TRIM

999

SUBSTRING

972

LENGTH

945

LOWER

742

REPLACE

738

INSERT INTO

627

DROP COLUMN

606

INSERT INTO

531

DESCRIBE

510

UPPER

456

SUBSTR

428

LEFT JOIN

359

CREATE OR REPLACE PROCEDURE

359

INNER JOIN

310

REVERSE

300

JSON_CONTAINS

263

DROP CONSTRAINT

257

236

JSON_ARRAY

215

DROP FUNCTION

183

INSERT INTO

174

IFNULL

164

INSERT INTO

146

PRIMARY KEY

138

JSON_AGG

132

LTRIM

106

NULLIF

84

GROUP BY

76

CREATE OR REPLACE TRIGGER

73

LPAD

62

RTRIM

59

ORDER BY

53

ADD COLUMN

51

46

CREATE OR REPLACE FUNCTION

46

CREATE OR REPLACE VIEW

45

DROP TABLE

38

DROP INDEX

30

INSERT INTO

30

DROP TRIGGER

28

INSERT INTO

24

CROSS JOIN

24

UUID_GENERATE_V4

22

INSERT INTO

21

21

RPAD

20

CREATE OR REPLACE FUNCTION

17

GROUP BY

17

DROP SEQUENCE

15

13

© 2023 SQLize - format run and share SQL queries online | About project | Disclaimer |

our telegram chat
PHP versions:
Warning: implode(): Invalid arguments passed in /code/templates_c/c20a124ec93441b64cbdf93bf5e1b7211243ec47_0.file.footer.tpl.php on line 37

RDBMS versions:
Warning: implode(): Invalid arguments passed in /code/templates_c/c20a124ec93441b64cbdf93bf5e1b7211243ec47_0.file.footer.tpl.php on line 39