Re: ERROR 1064 (42000) with triggers
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?
Subject
Views
Written By
Posted
5668
December 11, 2011 12:48PM
2018
December 11, 2011 01:58PM
1963
December 11, 2011 02:38PM
1952
December 11, 2011 02:59PM
Re: ERROR 1064 (42000) with triggers
2318
December 11, 2011 03:19PM
1696
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.