SQLize - format run and share SQL queries online

Tags: MySQL 5.7 MySQL 5.7 (Sakila - ReadOnly) MySQL 8.0 MySQL 8.0 (Sakila - ReadOnly) MariaDB 10 MariaDB 10 (Sakila - ReadOnly) 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 (HR) Oracle Database 21c Oracle Database 23c Free SOQOL (beta)

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

SELECT

239k

CREATE TABLE

237k

INSERT INTO

214k

WHERE

143k

PRIMARY KEY

137k

NOT

120k

AND

73k

FOREIGN KEY

63k

JOIN

60k

GROUP BY

59k

ORDER BY

56k

CONSTRAINT

55k

COUNT

51k

AUTO_INCREMENT

47k

WITH

46k

DROP TABLE

45k

DEFAULT

44k

INNER JOIN

32k

LEFT

31k

UPDATE

28k

SUM

25k

DELETE

20k

CREATE VIEW

17k

ALTER TABLE

16k

15k

HAVING

14k

BETWEEN

13k

DROP VIEW

12k

CASE

12k

CREATE PROCEDURE

10k

ROW_NUMBER

DROP PROCEDURE

MONTH

EXEC

SHOW

RIGHT

CONCAT

LAG

ADD CONSTRAINT

CREATE FUNCTION

CREATE OR REPLACE FUNCTION

COALESCE

LEAD

OUTER JOIN

CROSS JOIN

DENSE_RANK

ADD COLUMN

TRUNCATE

INSERT INTO

SUBSTRING

UPPER

LENGTH

REPLACE

TRIM

LOWER

CREATE OR REPLACE VIEW

992

CREATE OR REPLACE PROCEDURE

934

DROP COLUMN

931

INSERT INTO

878

JSON_CONTAINS

866

DESCRIBE

733

SUBSTR

719

IFNULL

695

LEFT JOIN

491

INSERT INTO

456

REVERSE

395

JSON_ARRAY

337

INNER JOIN

315

DROP CONSTRAINT

313

ADD CONSTRAINT

298

UUID_GENERATE_V4

279

DROP FUNCTION

255

INSERT INTO

228

CREATE OR REPLACE TRIGGER

218

NULLIF

206

ORDER BY

205

LTRIM

171

RTRIM

144

JSON_AGG

144

PRIMARY KEY

138

LPAD

119

GROUP BY

110

DAYOFWEEK

104

DROP TRIGGER

INSERT INTO

ADD COLUMN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

RPAD

ROW_TO_JSON

DROP INDEX

CREATE TABLE

DROP TABLE

DROP SEQUENCE

INSERT INTO

CROSS JOIN

ADD CONSTRAINT

our telegram chat
PHP versions: PHP 5.6, PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2.3
RDBMS versions: MySQL 5.7, MySQL 5.7 (Sakila - ReadOnly), MySQL 8.0, MySQL 8.0 (Sakila - ReadOnly), MariaDB 10, MariaDB 10 (Sakila - ReadOnly), 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 (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL (beta)

SQLize Online / PHPize Online

PRIMARY KEY - Popular snippets

PRIMARY KEY - New snippets

SQLize.online - Popular functions