mysql trigger ÖÐÎÄ×Ö¶ÎÎÊÌâ

ÓÐÕâÑùµÄÒ»¸ö´¥·¢Æ÷
DELIMITER $$

DROP TRIGGER /*!50032 IF EXISTS */ `mysqlwebproject`.`ChannelName`$$

create trigger `mysqlwebproject`.`ChannelName` BEFORE INSERT on `mysqlwebproject`.`powerchannel`
for each row BEGIN
DECLARE aa varchar (250) ;
select CannelName into aa from cannel where ID=new.ChannelID;
set NEW.ChannelName=aa ;
END;
$$

DELIMITER ;

¹¦ÄÜ£ºµ±insertÒ»ÌõмǼʱ£¬¸ù¾Ýµ±Ç°¼Ç¼ÖеÄÒ»¸öID Ϊµ±Ç°¼Ç¼Ìí¼ÓÒ»¸ö×Ö¶ÎÖµ

Ä¿Ç°¹¦ÄÜ¿ÉÒÔʵÏÖÁË£¬µ«ÊdzöÏÖµÄÎÊÌâÊÇ£¬µ± CannelName ÄÚÈÝΪÖÐÎÄʱ£¬³öÏÖÂÒÂë¡£

---

×Ö·û¼¯ÎÊÌâ
show variables like 'char%';

---

û¿´¶®£¬Äܲ»ÄÜϸ˵˵

---

лл3Â¥µÄÅóÓÑÎÊÌâ½â¾ö

Ô­À´±äÁ¿Ò²ÄÜÉèÖà ×Ö·û¼¯£¬ºÇºÇ£¬Ñ§Ï°ÁË

Ð޸ĺóÊÇÕâÑùµÄ£º

DELIMITER $$

DROP TRIGGER /*!50032 IF EXISTS */ `mysqlwebproject`.`ChannelName`$$

create trigger `mysqlwebproject`.`ChannelName` BEFORE INSERT on `mysqlwebproject`.`powerchannel`
for each row BEGIN
DECLARE aa varchar (250) charset 'gbk';  //Ìí¼ÓÁËÕâÀï
select CannelName into aa from cannel where ID=new.ChannelID;
set NEW.ChannelName=aa ;
END;
$$

DELIMITER ;