Posted by Kenoli on 01/22/08 20:29

I want to insert the data from one record in one table into another
table in a mysql database, adding the current date and time to a field
in the table the data is going into. Thus when a record is changed, I
am backing it up and indicating the date and time of the backup in a
"date" field.

The following is the method for copying data from a field in one table
to another.

INSERT INTO tbl_2 (fld_1, fld_2) SELECT tbl_1.fld_1, tbl_1.fld_2 FROM
tb_1 WHERE tbl_1.fld_id = [some record number];

How can I mix this with adding the new date/time data to a date field
in table 2 as well?

Thanks,

--Kenoli

[Back to original message]