mysql ´¥·¢Æ÷µÄÐÂÊÖÎÊÌâ.

±ítab3 Èç¹ûID´óÓÚ5,×Ô¶¯¸ÄΪ5,
Create table tab3(id int not null);
Create trigger inser_update_a
Before insert or update on tab3
FOR each ROW 
AS BEGIN 
IF tab3.id >5
then tab3.id= 5
end if
end ;
 ÉÏÃæÓдíÂð, ÎÒÔËÐв»³öÀ´,±¨´í:
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or update on tab3
FOR each ROW 
AS BEGIN 
IF tab3.id >5
then tab3.id= 5
end if
e' at line 2


ÇëÎʸ÷λÊÇÔõô»ØÊÂÄØ..

---

Before insert or update on tab3

MySQL²»Ö§³ÖÕâÖÖÓï·¨£¬Ö»ÄÜ·Ö¿ªÐ´¡£Ð´Á½¸ö´¥·¢Æ÷·Ö±ðÊÇ

Create trigger inser_update_a_1 before insert ....

Create trigger inser_update_a_2 before update ....

---

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

---

ACMAIN_CHM:
 ÄãºÃ,
ÎÒ°Ñupdate ɾÁË,ÔËÐÐ:
Create trigger inser_update_a
Before insert on tab3
FOR each ROW 
AS BEGIN 
IF tab3.id >5
then tab3.id= 5
end if
end ;
Óï·¨ÉÏÓ¦¸Ãû´í,ÎÒÊÇ¿´ÁËÊý¾Ý¿âϵͳ¸ÅÂÛÀïÃæµÄÒ»¸öÀý×Ó,ÔÙÓñ¾µØµÄ×öÏÂʵÑé,µ«ÊÇ»¹ÊDZ¨´í:
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS BEGIN 
IF tab3.id >5
then tab3.id= 5
end i