Tags: MySQL 5.7 MySQL 8.0 MariaDB 10 SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 MS SQL Server 2017 MS SQL Server 2019
UPADTE - Popular snippets
- MySQL 5.7 CREATE TABLE SELECT INSERT INTO UPADTE
last run:
2022-02-21 19:08:57
33
UPADTE - New snippets
-
MySQL 5.7 CREATE TABLE SELECT INSERT INTO UPADTE
added at:
2021-02-10 08:38:30
33
SQLize.online - Popular functions
CREATE TABLE55k
SELECT 48k
INSERT INTO 48k
WHERE 28k
PRIMARY KEY 26k
NOT 18k
GROUP BY 14k
COUNT 14k
ORDER BY 12k
JOIN 12k
AND 12k
FOREIGN KEY 10k
UPDATE 8k
WITH 8k
AUTO_INCREMENT 7k
DELETE 6k
IN 6k
SUM 6k
LEFT 6k
INNER JOIN 5k
ALTER TABLE 5k
LIKE 4k
OR 3k
CONSTRAINT 3k
BETWEEN 3k
DEFAULT 3k
HAVING 3k
CASE 2k
SHOW 2k
ROW_NUMBER 1k
TRUNCATE 1k
LAG 1k
MONTH 1k
CONCAT 1k
OUTER JOIN 1k
CREATE VIEW 991
ADD COLUMN 919
DROP TABLE 910
EXEC 892
CREATE FUNCTION 733
TRIM 692
DENSE_RANK 673
RIGHT 663
COALESCE 557
ADD CONSTRAINT 507
DROP COLUMN 482
CROSS JOIN 447
LEAD 423
SUBSTRING 415
LENGTH 398
REPLACE 375
LOWER 279
UPPER 274
CREATE OR REPLACE FUNCTION 234
LEFT JOIN 225
SUBSTR 185
DESCRIBE 166
REVERSE 118
INSERT
INTO 112
IFNULL 98
JSON_ARRAY 86
DROP CONSTRAINT 73
ADD CONSTRAINT 71
INSERT
INTO 59
CREATE PROCEDURE 52
RTRIM 51
ADD
COLUMN 50
LPAD 42
JSON_AGG 40
ADD
CONSTRAINT 39
ORDER BY 37
INSERT
INTO 29
JSON_CONTAINS 27
INSERT
INTO 24
CROSS JOIN 23
DROP PROCEDURE 21
DROP INDEX 21
NULLIF 20
INSERT INTO 17
GROUP BY 17
DROP
TABLE 13
CREATE OR REPLACE VIEW 13
ROW_TO_JSON 12
ORDER BY 12
DROP VIEW 10
CREATE
OR REPLACE FUNCTION 9
INNER
JOIN 9
LTRIM 8
UUID_GENERATE_V4 7
CREATE TABLE 4
DROP TRIGGER 4
INSERT INTO 3
RIGTH JOIN 3
DROP FUNCTION 3
CREATE
OR REPLACE FUNCTION 3
RANDOM() 2
CROSS
JOIN 2
CREATE
OR REPLACE VIEW 2
CROSS
JOIN 2
@@VERSION 1
© 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.33, 8.0.23, MariaDB 10.5.9, PostgreSQL 11.9, 12.4, 13.2, 14.0, Microsoft SQL Server 2017, 2019, SQLite 3
PHP versions: 5.6.40, 7.4.14, 8.0.1, 8.1.5 | RDBMS versions: MySQL 5.7.33, 8.0.23, MariaDB 10.5.9, PostgreSQL 11.9, 12.4, 13.2, 14.0, Microsoft SQL Server 2017, 2019, SQLite 3