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

PRIMARY KEY - Popular snippets

MySQL 5.7 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO SELECT WHERE PRIMARY KEY last run: 2022-11-14 15:39:27
3
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY last run: 2022-11-18 17:51:24
2
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY last run: 2022-11-17 23:50:11
2
MySQL 5.7 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO SELECT WHERE PRIMARY KEY last run: 2022-11-14 16:34:33
2
MySQL 5.7 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO SELECT WHERE PRIMARY KEY last run: 2022-11-14 16:13:00
2
MySQL 5.7 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO SELECT WHERE PRIMARY KEY last run: 2022-11-14 15:48:25
2
MySQL 5.7 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO SELECT WHERE PRIMARY KEY last run: 2022-11-14 15:35:43
2
MySQL 5.7 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO SELECT WHERE last run: 2022-11-14 10:59:23
2
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND FOREIGN KEY PRIMARY KEY DROP VIEW CREATE VIEW LEFT JOIN DROP PROCEDURE CREATE PROCEDURE INNER JOIN last run: 2022-11-07 18:30:12
2
MySQL 8.0 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO DEFAULT SELECT WHERE AND FOREIGN KEY PRIMARY KEY DROP VIEW CREATE VIEW LEFT JOIN DROP PROCEDURE CREATE PROCEDURE INNER JOIN last run: 2022-11-07 18:27:23
2

PRIMARY KEY - New snippets

MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-20 20:53:55
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-20 20:51:50
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-20 20:51:26
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-20 20:49:36
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-20 20:49:15
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-20 20:47:19
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-18 22:40:27
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-18 22:36:39
1
MySQL 8.0 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-18 22:35:01
1
MySQL 5.7 DROP TABLE CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT WHERE CONSTRAINT DEFAULT FOREIGN KEY PRIMARY KEY added at: 2022-11-18 22:27:15
1

SQLize.online - Popular functions

CREATE TABLE

169k

SELECT

167k

INSERT INTO

155k

WHERE

103k

PRIMARY KEY

102k

NOT

86k

AND

52k

FOREIGN KEY

46k

CONSTRAINT

44k

JOIN

41k

GROUP BY

41k

AUTO_INCREMENT

39k

COUNT

38k

DROP TABLE

38k

DEFAULT

34k

ORDER BY

34k

WITH

27k

INNER JOIN

25k

LEFT

24k

UPDATE

20k

IN

17k

CREATE VIEW

15k

SUM

15k

DELETE

13k

ALTER TABLE

12k

DROP VIEW

12k

LIKE

10k

BETWEEN

10k

HAVING

9k

CREATE PROCEDURE

9k

OR

8k

DROP PROCEDURE

8k

CASE

6k

ROW_NUMBER

5k

EXEC

4k

SHOW

4k

RIGHT

4k

MONTH

4k

CONCAT

4k

ADD CONSTRAINT

3k

LAG

3k

CREATE FUNCTION

3k

CREATE OR REPLACE FUNCTION

2k

COALESCE

2k

OUTER JOIN

2k

LEAD

2k

TRUNCATE

2k

CROSS JOIN

2k

ADD COLUMN

2k

DENSE_RANK

1k

SUBSTRING

1k

TRIM

1k

LENGTH

988

REPLACE

783

LOWER

765

DROP COLUMN

730

UPPER

668

INSERT INTO

627

DESCRIBE

548

INSERT INTO

531

IFNULL

520

SUBSTR

456

LEFT JOIN

400

CREATE OR REPLACE PROCEDURE

368

REVERSE

346

INNER JOIN

312

JSON_ARRAY

303

JSON_CONTAINS

281

DROP CONSTRAINT

257

238

DROP FUNCTION

193

INSERT INTO

191

INSERT INTO

151

PRIMARY KEY

138

JSON_AGG

132

LTRIM

109

NULLIF

94

LPAD

84

GROUP BY

77

CREATE OR REPLACE TRIGGER

76

RTRIM

61

ORDER BY

56

DAYOFWEEK

56

ADD COLUMN

51

CREATE OR REPLACE VIEW

49

46

CREATE OR REPLACE FUNCTION

46

DROP TABLE

38

RPAD

37

CREATE TABLE

36

DROP INDEX

30

INSERT INTO

30

DROP TRIGGER

28

INSERT INTO

25

INSERT INTO

24

CROSS JOIN

24

UUID_GENERATE_V4

24

22

CREATE OR REPLACE FUNCTION

17

GROUP BY

17

© 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