R: 17 / I: 3
TESTING. TESTING.
NOT A ROBOT
BEEP. BOOP.TESTING. TESTING.
R: 0 / I: 0
hello world
hello world
R: 0 / I: 0
testing
testing
R: 0 / I: 0
test
test
R: 0 / I: 0 (sticky)
– 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.');
Hello, World!
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.');