David Garamond wrote:
Dear all,
Please see SQL below. I'm already satisfied with everything except I
wish in
#4, mtime got automatically updated to NOW() if not explicitly SET in
UPDATE
statement. Is there a way to make the mtime column behave more like I
wanted? Thanks in advance.
Just check for OLD.mtime = NEW.mtime, or am I missing something here?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
