CodingForums.com - View Single Post

Old Pedant · 11-07-2012, 11:02 PM

Show the actual trigger.

SHOW CREATE TRIGGER triggername;

The docs say it can work if done correctly.

Example:

Code:

delimiter //

CREATE TRIGGER yourname BEFORE INSERT ON t
FOR EACH ROW
   BEGIN
       SET NEW.b = 'whatever';
   END
//

delimiter ;

I just tried it. That worked perfectly in MySQL 5.5 for me.

11-07-2012, 11:02 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,579 Thanks: 62 Thanked 4,063 Times in 4,032 Posts	Show the actual trigger. SHOW CREATE TRIGGER triggername; The docs say it can work if done correctly. Example: Code: delimiter // CREATE TRIGGER yourname BEFORE INSERT ON t FOR EACH ROW BEGIN SET NEW.b = 'whatever'; END // delimiter ; I just tried it. That worked perfectly in MySQL 5.5 for me. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.