Posted by Ian Pawson on 01/23/08 15:36

Kenoli wrote:
> 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
>
There is a field type that does this automatically - it auto updates
with the current_timestamp - have a look at TIMESTAMP

[Back to original message]