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,
>
&
Sent: Tuesday, June 18, 2002 9:38 AM
Subject: RE: How to duplicate records
> mabye an insert into...select will work, something like:
>
> INSERT INTO
> SELECT Code, Model, Units
> from
> where Year=2003
> and ((Code = 'N200') or (Code='N205'));
>
mabye an insert into...select will work, something like:
INSERT INTO
SELECT Code, Model, Units
from
where Year=2003
and ((Code = 'N200') or (Code='N205'));
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
-Don
-Original Message-
From: Carlos Fernando Scheidecker Antunes [mailto:[EM
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
