UPDATE - Popular snippets
- MariaDB 11.5 CREATE TABLE NOT AUTO_INCREMENT DEFAULT UPDATE PRIMARY KEY INSERT INTO SELECT WHERE GROUP BY AND LEFT JOIN INNER JOIN ORDER BY
last run:
2024-12-03 12:28:55
184
- MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT
INTO INSERT INTO EXEC IN SELECT
last run:
2025-01-21 02:50:13
74
- PostgreSQL 15 CREATE TABLE DEFAULT PRIMARY KEY INSERT INTO LEAD NOT UPDATE SELECT
last run:
2025-01-04 19:02:59
68
- PostgreSQL 14 CREATE TABLE INSERT INTO LENGTH SUM UPDATE SELECT TRIM REPLACE
last run:
2024-11-22 08:47:41
60
- MySQL 8.0 CREATE TABLE NOT AUTO_INCREMENT DEFAULT UPDATE PRIMARY KEY INSERT INTO SELECT WHERE GROUP BY AND LEFT JOIN INNER JOIN ORDER BY
last run:
2024-12-03 12:29:18
58
- MySQL 5.7 UPDATE SUM WITH AND NOT CREATE TABLE CONSTRAINT PRIMARY KEY FOREIGN KEY INSERT
INTO INSERT INTO EXEC IN SELECT
last run:
2025-01-18 22:02:46
46
- MariaDB 11.5 CREATE TABLE NOT AUTO_INCREMENT DEFAULT UPDATE PRIMARY KEY INSERT INTO SELECT WHERE GROUP BY AND LEFT JOIN INNER JOIN ORDER BY
last run:
2024-12-03 13:29:39
38
- CREATE TABLE NOT AUTO_INCREMENT DEFAULT UPDATE PRIMARY KEY INSERT INTO SELECT WHERE GROUP BY AND LEFT JOIN INNER JOIN ORDER BY
last run:
2024-12-03 12:29:06
34
- PostgreSQL 15 CREATE TABLE INSERT INTO MONTH WITH SELECT JOIN SUBSTRING UPDATE CASE AND IN WHERE COUNT NOT
last run:
2024-12-04 12:38:44
30
- MySQL 5.7 CREATE TABLE INSERT INTO UPDATE SELECT
last run:
2024-06-15 00:25:11
29
UPDATE - New snippets
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT UPDATE SELECT FOREIGN KEY INSERT INTO RIGHT OUTER JOIN
added at:
2025-01-22 15:08:23
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT UPDATE SELECT FOREIGN KEY INSERT INTO RIGHT OUTER JOIN
added at:
2025-01-22 15:08:04
1
-
Oracle Database 21c CREATE TABLE INSERT INTO SELECT INNER JOIN WHERE UPDATE AND DROP TABLE
added at:
2025-01-22 13:25:09
1
-
PostgreSQL 15 CREATE TABLE INSERT INTO SELECT INNER JOIN WHERE UPDATE AND DROP TABLE
added at:
2025-01-22 13:24:50
1
-
SQLite 3 UPDATE SELECT WHERE AND NOT ORDER BY
added at:
2025-01-22 12:00:04
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT WHERE UPDATE
added at:
2025-01-22 09:39:48
4
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT UPDATE SELECT FOREIGN KEY INSERT INTO RIGHT OUTER JOIN
added at:
2025-01-22 08:06:48
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT UPDATE SELECT FOREIGN KEY INSERT INTO RIGHT OUTER JOIN
added at:
2025-01-22 08:06:04
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT UPDATE SELECT FOREIGN KEY INSERT INTO RIGHT OUTER JOIN
added at:
2025-01-22 08:03:44
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT UPDATE SELECT FOREIGN KEY INSERT INTO RIGHT OUTER JOIN
added at:
2025-01-22 07:58:04
1