Posted by Kenoli on 01/23/08 00:15

On Jan 22, 1:00 pm, ZeldorBlat <zeldorb...@gmail.com> wrote:
> On Jan 22, 3:29 pm, Kenoli <kenol...@gmail.com> 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
>
> Just include another column with the value of NOW():
>
> INSERT INTO tbl_2 (fld_1, fld_2, fld_date)
> SELECT tbl_1.fld_1, tbl_1.fld_2, NOW()
> FROM tb_1
> WHERE tbl_1.fld_id = [some record number];

Thanks. I'll try it. And it won't get confused looking for a NOW()
field in tbl_1?

--Kenoli

• Next in forum: Re: Backing up from one table to another and adding date/time information
• Prev in forum: Re: Backing up from one table to another and adding date/time information
• Thread view: Re: Backing up from one table to another and adding date/time information

[Reply to this message]