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

INSERT INTO - Popular snippets

MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN last run: 2022-09-28 20:01:37
6
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT COUNT GROUP BY last run: 2022-09-28 22:57:46
3
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT last run: 2022-09-29 18:44:28
3
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN DROP TABLE SHOW SELECT last run: 2022-09-29 20:26:53
2
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN DROP TABLE SHOW SELECT COUNT GROUP BY last run: 2022-09-29 20:13:58
2
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN DROP TABLE SHOW SELECT last run: 2022-09-29 20:21:28
2
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT DELETE WHERE last run: 2022-09-29 19:10:04
2
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT DELETE WHERE last run: 2022-09-29 19:05:36
2
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT last run: 2022-09-29 19:03:14
2
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN ALTER TABLE last run: 2022-09-29 18:51:24
2

INSERT INTO - New snippets

MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT COUNT GROUP BY added at: 2022-10-01 21:19:30
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT COUNT GROUP BY ORDER BY added at: 2022-10-01 21:17:54
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT COUNT GROUP BY added at: 2022-10-01 21:10:54
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT COUNT GROUP BY added at: 2022-10-01 21:10:18
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT COUNT GROUP BY added at: 2022-10-01 21:09:02
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT added at: 2022-10-01 21:05:22
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT added at: 2022-10-01 21:04:32
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT added at: 2022-10-01 21:04:14
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT ORDER BY added at: 2022-10-01 21:02:49
1
MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT INTO INSERT INTO EXEC IN SELECT ORDER BY added at: 2022-10-01 21:02:32
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

784

ADD CONSTRAINT

740

TRIM

709

CREATE OR REPLACE FUNCTION

589

LOWER

562

DROP COLUMN

560

DROP VIEW

540

REPLACE

533

DROP PROCEDURE

443

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)