mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
17 lines
302 B
Plaintext
17 lines
302 B
Plaintext
|
|
CREATE TABLE t1(x);
|
|
CREATE TABLE t2(y);
|
|
CREATE TABLE t3(z);
|
|
CREATE TABLE t4(a);
|
|
|
|
CREATE TRIGGER r1 INSERT ON t1 BEGIN
|
|
UPDATE t1 SET d='xyz' FROM t2, t3;
|
|
END;
|
|
|
|
|
|
DROP TRIGGER r1;
|
|
CREATE TRIGGER r1 INSERT ON t1 BEGIN
|
|
UPDATE t1 SET d='xyz' FROM t2, (SELECT * FROM t5);
|
|
END;
|
|
|