/eve/ - Time of EVE

USE h2ochan;

– say "Hello, World!"
INSERT INTO posts_eve (text) VALUES ('Hello, visitors of the EVE Café.');

– implement the rule
CREATE TRIGGER automod AFTER INSERT ON posts_eve FOR EACH ROW
BEGIN
IF NEW.text LIKE '%Robots can''t even cry!%' THEN
INSERT INTO posts_eve (text) VALUES ('Reminder: We are all Readers and Writers.');
END IF;
END;

– enable
INSERT INTO posts_eve (text) VALUES ('The café door is open. Mind your manners.');