On 20 Jun 2002, at 11:35, Richard DeWath wrote:
> Just a thought on something I was reading with temp tables:
>
> 1. extract the records you want to change the date on from your existing
> table to a temp table.
> 2. update the date in the temp table
> 3. insert the "new" records back into t
ically, or subselects (slated for 4.1?).
>
> -Original Message-
> From: Carlos Fernando Scheidecker Antunes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 2:40 PM
> To: Don Vu
> Cc: MySQL List
> Subject: Re: How to duplicate records
>
>
> Don,
>
&
> http://www.mysql.com/doc/I/N/INSERT_SELECT.html
>
> -Don
>
> -Original Message-
> From: Carlos Fernando Scheidecker Antunes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 10:25 AM
> To: MySQL List
> Subject: How to duplicate records
> Importance: High
&
cker Antunes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 10:25 AM
To: MySQL List
Subject: How to duplicate records
Importance: High
Hello all,
I've got some records of a Database that I would like to duplicate if
possible with an statement.
The table has Code, Model, Year, units
Carlos,
Tuesday, June 18, 2002, 5:24:48 PM, you wrote:
CFSA> I've got some records of a Database that I would like to duplicate if
CFSA> possible with an statement.
CFSA> The table has Code, Model, Year, units. The primary key is Code, Model and
CFSA> Year. What I need is to duplicate Code, Mode
Hello all,
I've got some records of a Database that I would like to duplicate if
possible with an statement.
The table has Code, Model, Year, units. The primary key is Code, Model and
Year. What I need is to duplicate Code, Model and units for a different
year.
Say I want to duplicate all recor
