"Richard Huxton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Pradeepkumar, Pyatalo (IE10) wrote: > > IF UPDATE(CreateTime) THEN > > .... > > .... > > END IF; > > > > Is this syntax correct. > > No, and I don't recall seeing anything like it in the manuals.
... and it's always an excellent time to read them ... > IF OLD.CreateTime <> NEW.CreateTime THEN > ... ... being mindful of the case where CreateTime might be NULL ... ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
