Triggers in MySQL 5
Peter Gulutzan shows a sneak peak of Trigger support in MySQL 5 alpha in his article MySQL Triggers Tryout on O'Reilly OnLamp.
You sent updating in MySQL 5.x , Documentation in MySQL all version , Syntax Trigger and Path Downlaod Graphic MySQL 5.x
CREATE OR REPLACE TRIGGER tr_id before insert on comment for each row declare @maxid int; @mon int(2); @yr varchar(4); @finyr varchar(10); begin set mon:=to_number(to_char(:new.dt,'mm')); set yr:=to_char(:new.dt,'yy'); if mon>=4 then set finyr:=trim(yr)||'-'||trim(to_char(to_number(yr)+1,'00')); else set finyr:=to_char(to_number(yr)-1)||'-'||yr; end if; select max(comnocode) into maxid from comment; if maxid is null then set :new.compno:=1; set :new.comnocode:=finyr||'1'; else set :new.compno:=maxid+1; set :new.comnocode:='w'||trim(finyr)||'/'||trim(to_char(maxid+1,'00')); end if; end; #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 'TRIGGER tr_id before insert on comment for each row declare set @maxid int' at line 1
I think CREATE or REPLACE only works in sql only
gggggggggggggggggggggggggggggggg j j j jj j j j j j j j j j j j j j j l l ll o o i i i i i i
The only host I found so far to support mysql triggers on shared packages is at http://www.placehost.net. I hope more will come. This is probably because hosting providers wait for plesk or cpanel to support such versions of PHP/MySql and those two are moving slower than anything else. PHP 5.2.9 came out recently and a lot of bugs were fixed yet nor cpanel or plesk supports this version. Mysql releases 5.4 soon so triggers will no longer need the super user privilege to be added, but, as always, how much time will the control panels need to support it?
I'm impressed! You've maanged the almost impossible.
- Tomcat Virtual Directory Howto
- Communications link failure MySQL JDBC with TLS
- Redirect www and non https in IIS using web.config
- Not authorized to perform: ssm:GetParameters
- What is the difference between ASCII Chr(10) and Chr(13)
- Fixinator and Foundeo Security Bundle
- Running CFML on AWS Lambda with FuseLess Slides
- Updating Java on ColdFusion or Lucee