#Ïò 30. äåê 23:19:56 2005 

create database trigger_test; 

 

 

#Ïò 30. äåê 23:20:07 2005 

use trigger_test; 

 

#Ïò 30. äåê 23:20:16 2005 

set names cp1251;

 

 

 #Ïò 30. äåê 23:21:39 2005 

create table `òàáëèöà`(`áèò` bit); 

 

#Ïò 30. äåê 23:26:13 2005 

CREATE TRIGGER `trigger_test`.`òðèããåð` BEFORE UPDATE on `trigger_test`.`òàáëèöà` 

FOR EACH ROW BEGIN 

SET NEW.`áèò`=OLD.`áèò`; 

#more then 16 bytes

END; 

 

#Ïò 30. äåê 23:26:29 2005 

show triggers;