Re: SQL syntax for INSERT

Randy Harris <randy.harris_at_nospam.net> wrote:
> This works, however I would like to also add the SYSDATE to the resulting
> record. If I add a DATE field to the destination table the above INSERT no
> longer works. I've tried things like:

INSERT INTO events_deleted SELECT SYSDATE, events.* FROM events WHERE...

Davide Received on Sat May 25 2002 - 13:55:02 CDT