Sorry for responding to my own message. I figured this out.
DELIMITER //
CREATE TRIGGER only_this AFTER INSERT ON table_a
FOR EACH ROW
BEGIN
IF NEW.email_addr LIKE '[EMAIL PROTECTED]' THEN
INSERT INTO table_b (email_addr,value) VALUES (NEW.email_addr,0);
END IF;
END
On Saturday, January 7
Hello All,
I've been racking my brain trying to figure out something. I'm
relatively new to the arena of SQL and have been doing a bunch of
reading and experimenting.
I have found a need for a trigger that will fire after an insert
into a table. The trigger needs to act on
