PHWinfo - Afficher un message

06/09/2007, 14h00

Hi all,

When I am trying to create a trigger I get an error message which I am
unable to comprehend.

create trigger updatepricech
after insert on tbl_prices for each row
BEGIN
DECLARE closep INTEGER;

select close into closep from temptable where Ticker = new.Ticker;
update tbl_prices set PriceCh = (Close - closep) where Ticker = new.Ticker
and Trade_date = new.Trade_date;
end;

I get the error :

#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 ''
at line 4

Here line 4 is the declaration part.

Can you please let me know what could be wrong in this query?
--
View this message in context: http://www.nabble.com/Problem-creati...html#a12522149
Sent from the MySQL - General mailing list archive at Nabble.com.

06/09/2007, 14h00	#1
anniyan Messages: n/a Hébergeur:	Problem creating a Trigger Hi all, When I am trying to create a trigger I get an error message which I am unable to comprehend. create trigger updatepricech after insert on tbl_prices for each row BEGIN DECLARE closep INTEGER; select close into closep from temptable where Ticker = new.Ticker; update tbl_prices set PriceCh = (Close - closep) where Ticker = new.Ticker and Trade_date = new.Trade_date; end; I get the error : #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 '' at line 4 Here line 4 is the declaration part. Can you please let me know what could be wrong in this query? -- View this message in context: http://www.nabble.com/Problem-creati...html#a12522149 Sent from the MySQL - General mailing list archive at Nabble.com.