MySQL Forums
Forum List  »  Triggers

Re: ERROR 1064 (42000) with triggers
Posted by: mahmoud ahmadinejad
Date: December 11, 2011 03:19PM

ok thank you

i have modified the trigger to be like this

CREATE TRIGGER change_capital BEFORE UPDATE ON country
FOR each ROW
set anciennecap = old.Capital;
end|

but now it tells me this

ERROR 1193 (HY000): Unknown system variable 'anciennecap'

Can i do set anciennecap = old.Capital;
Or do i have to do capital.anciennecap?

Options: ReplyQuote


Subject
Views
Written By
Posted
5285
December 11, 2011 12:48PM
1883
December 11, 2011 01:58PM
1755
December 11, 2011 02:59PM
Re: ERROR 1064 (42000) with triggers
2140
December 11, 2011 03:19PM
1545
December 11, 2011 05:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.