Run, Practice, Share: Your Interactive SQL Playground

Tags: MariaDB 11.4 MariaDB 11.5 MariaDB 10 MariaDB 10 Sakila (ReadOnly) MySQL 5.7 MySQL 5.7 Sakila (ReadOnly) MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) SQLite 3 PostgreSQL 10 Bookings (ReadOnly) PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 MS SQL Server 2022 AdventureWorks (ReadOnly) Firebird 4.0 Firebird 4.0 (Employee) Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free SOQOL

CREATE OR REPLACE TRIGGER - Popular snippets

Oracle Database 21c CREATE OR REPLACE TRIGGER UPDATE SELECT WHERE INSERT INTO last run: 2023-03-06 18:31:01
6
PostgreSQL 15 CREATE TABLE CREATE OR REPLACE FUNCTION UPDATE CASE CREATE OR REPLACE TRIGGER OR EXEC last run: 2024-02-23 10:47:39
5
PostgreSQL 15 CREATE TABLE PRIMARY KEY OR INSERT INTO SELECT COUNT INNER JOIN WHERE IN GROUP BY ORDER BY HAVING NOT CREATE OR REPLACE FUNCTION CREATE OR REPLACE TRIGGER UPDATE EXEC last run: 2023-01-09 20:55:17
5
PostgreSQL 15 DROP TABLE CREATE TABLE INSERT INTO CREATE OR REPLACE FUNCTION OR CREATE OR REPLACE TRIGGER UPDATE EXEC WHERE SELECT last run: 2024-04-26 11:56:40
4
Oracle Database 23c Free CREATE TABLE NOT CREATE OR REPLACE TRIGGER AUTO_INCREMENT SELECT COALESCE last run: 2023-09-18 10:04:03
4
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT FOREIGN KEY DELETE INSERT INTO SELECT ORDER BY CREATE OR REPLACE VIEW JOIN DROP VIEW CREATE OR REPLACE PROCEDURE UPDATE WHERE AND CREATE OR REPLACE FUNCTION CREATE OR REPLACE TRIGGER EXEC last run: 2023-06-08 13:40:32
4
PostgreSQL 14 CREATE TABLE CREATE OR REPLACE FUNCTION SELECT WHERE CREATE OR REPLACE VIEW JOIN INSERT INTO CREATE OR REPLACE TRIGGER EXEC last run: 2023-04-29 21:21:22
4
PostgreSQL 14 CREATE TABLE CREATE OR REPLACE FUNCTION SELECT WHERE CREATE OR REPLACE VIEW JOIN CREATE OR REPLACE TRIGGER EXEC INSERT INTO last run: 2023-05-17 19:02:29
4
PostgreSQL 15 CREATE TABLE PRIMARY KEY DELETE OR INSERT INTO SELECT COUNT INNER JOIN WHERE IN GROUP BY ORDER BY HAVING NOT CREATE OR REPLACE FUNCTION AND CREATE OR REPLACE TRIGGER UPDATE EXEC last run: 2023-05-21 11:54:01
4
Oracle Database 21c CONSTRAINT ALTER TABLE DROP CONSTRAINT DROP TABLE CREATE TABLE DEFAULT PRIMARY KEY NOT ADD CONSTRAINT FOREIGN KEY DELETE IN BETWEEN AND INSERT INTO SELECT WHERE GROUP BY JOIN COUNT LEFT CREATE OR REPLACE TRIGGER OR UPDATE last run: 2024-04-04 09:18:04
3

CREATE OR REPLACE TRIGGER - New snippets

MySQL 5.7 CREATE TABLE PRIMARY KEY SELECT CREATE OR REPLACE TRIGGER DELETE OR UPDATE added at: 2024-06-30 05:21:55
1
MySQL 5.7 CREATE TABLE PRIMARY KEY CREATE OR REPLACE TRIGGER DELETE OR UPDATE added at: 2024-06-30 05:21:26
1
MySQL 5.7 CREATE OR REPLACE TRIGGER DELETE OR UPDATE PRIMARY KEY added at: 2024-06-30 05:19:11
1
MySQL 5.7 CREATE TABLE PRIMARY KEY DROP TRIGGER CREATE OR REPLACE TRIGGER OR UPDATE DELETE added at: 2024-06-23 09:05:48
1
MySQL 5.7 CREATE TABLE PRIMARY KEY CREATE OR REPLACE TRIGGER OR UPDATE DELETE added at: 2024-06-23 09:03:45
1
Oracle Database 21c CREATE TABLE NOT DEFAULT CONSTRAINT PRIMARY KEY FOREIGN KEY OR IN SELECT COUNT WHERE AND CREATE OR REPLACE TRIGGER added at: 2024-06-20 04:19:52
1
Oracle Database 21c EXEC CREATE TABLE CREATE OR REPLACE TRIGGER added at: 2024-06-09 17:36:07
1
Oracle Database 23c Free EXEC CREATE TABLE CREATE OR REPLACE TRIGGER added at: 2024-06-09 17:36:01
1
PostgreSQL 15 DROP TABLE CREATE TABLE INSERT INTO CREATE OR REPLACE FUNCTION OR CREATE OR REPLACE TRIGGER UPDATE EXEC WHERE SELECT added at: 2024-04-26 11:57:53
1
PostgreSQL 15 CREATE TABLE CREATE OR REPLACE FUNCTION INSERT INTO CREATE OR REPLACE TRIGGER OR UPDATE EXEC WHERE SELECT added at: 2024-04-26 11:57:13
1

SQLize.online - Popular functions

SELECT

699k

WHERE

389k

CREATE TABLE

376k

INSERT INTO

338k

ORDER BY

253k

PRIMARY KEY

235k

NOT

218k

JOIN

199k

AND

185k

GROUP BY

175k

COUNT

133k

126k

FOREIGN KEY

111k

SHOW

97k

WITH

95k

CONSTRAINT

95k

AUTO_INCREMENT

86k

DROP TABLE

84k

LEFT

72k

DEFAULT

67k

INNER JOIN

66k

60k

SUM

56k

UPDATE

46k

HAVING

40k

LENGTH

35k

DELETE

32k

31k

BETWEEN

30k

ALTER TABLE

27k

CREATE VIEW

26k

CASE

24k

DROP VIEW

20k

CONCAT

19k

CREATE PROCEDURE

17k

MONTH

17k

EXEC

17k

ROW_NUMBER

17k

DROP PROCEDURE

14k

RIGHT

10k

REPLACE

10k

ADD CONSTRAINT

LAG

COALESCE

LEAD

DENSE_RANK

CREATE FUNCTION

CROSS JOIN

INSERT INTO

CREATE OR REPLACE FUNCTION

SUBSTRING

OUTER JOIN

TRUNCATE

ADD COLUMN

UPPER

LOWER

DROP COLUMN

SUBSTR

TRIM

INSERT INTO

CREATE OR REPLACE VIEW

CREATE OR REPLACE PROCEDURE

DESCRIBE

IFNULL

JSON_CONTAINS

REVERSE

DAYOFWEEK

963

LEFT JOIN

937

INSERT INTO

849

DROP CONSTRAINT

830

INSERT INTO

772

JSON_ARRAY

742

LPAD

674

UUID_GENERATE_V4

584

ORDER BY

468

INNER JOIN

404

INSERT INTO

366

ADD CONSTRAINT

346

NULLIF

340

DROP FUNCTION

327

CREATE OR REPLACE TRIGGER

318

GROUP BY

283

JSON_AGG

279

RTRIM

255

LTRIM

204

PRIMARY KEY

151

RPAD

137

DROP TRIGGER

115

FOREIGN KEY

104

ROW_TO_JSON

103

DROP SEQUENCE

DROP PROCEDURE

DROP INDEX

CREATE TABLE

ADD COLUMN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

INNER JOIN

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 5.6, PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2.13
RDBMS versions: MariaDB 11.4, MariaDB 11.5, MariaDB 10, MariaDB 10 Sakila (ReadOnly), MySQL 5.7, MySQL 5.7 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), SQLite 3, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), Firebird 4.0, Firebird 4.0 (Employee), Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL

SQLize Online / PHPize Online / SQLtest Online

CREATE OR REPLACE TRIGGER - Popular snippets

CREATE OR REPLACE TRIGGER - New snippets

SQLize.online - Popular functions