On Tue, Jul 06, 2010 at 12:55:22PM +0100, Andre Lopes wrote:
> update aau_utilizadores
> set group_id = 3
> where email = pEMAIL;
[..]
> If I use the clause WHERE only in "id" will not work fot both cases, or will
> work?
Yes, it'll do the "right thing". OLD always refers to the previous
version of the row and NEW refers to the new version of the row, you can
use as many or few of the columns as you want.
--
Sam http://samason.me.uk/