CREATE TRIGGER
create [temp] trigger [if not exists] {name} [before, after, instead of]
[delete, insert, update [of {column}]] on {table name} [for each row] [when {expr}]
begin
{stmt};
end
Example
CREATE TRIGGER trigerName AFTER INSERT
ON MyTable1
BEGIN
INSERT INTO MyTable2(ID, A_DATE) VALUES (new.ID, datetime('now'));
END
Chart for Data Science
-- Change first word "SELECT" to "LINE-SELECT"
SELECT LINE-SELECT
-- labels - first column
-- values - all columns 2..N
-- color column key - "_c": name_cFF00FF (HEX6)
-- Example :
LINE-SELECT name as label, cos(id) as cos_c1ab394, sin(id) as sin_cFF0000 FROM demo;
-- Example :
AREA-SELECT id as x, id as y FROM demo;
-- Example :
BAR-SELECT name as label, id as y FROM demo;
-- Example :
PIE-SELECT name as label, id as y FROM demo;