maybe it doesn't then in MySQL - it does elsewhere
Alan
> -Original Message-
> From: David Felio [mailto:david@;ark.org]
> Sent: Saturday, 9 November 2002 1:59
> To: MySQL List
> Subject: Re: Copy Records in a table...
>
>
> Is the implementation of thi
This style of insert does not work in MySQL. The two table names must
be different.
-Original Message-
From: Alan McDonald [mailto:alan@;meta.com.au]
Sent: Thursday, November 07, 2002 9:56 PM
To: Doug Coning; [EMAIL PROTECTED]
Subject: RE: Copy Records in a table...
insert into
sage-
From: Doug Coning [mailto:lists@;coning.com]
Sent: Friday, 8 November 2002 14:35
To: [EMAIL PROTECTED]
Subject: Copy Records in a table...
Hi everyone,
I'm still learning MySQL. I have a database of 600 items. I am still
adding products. Several of these products are identical in na
insert into mytable(field1, field2, field3) select field1, field2, newvalue
from mytable where productcode=xx
> -Original Message-
> From: Doug Coning [mailto:lists@;coning.com]
> Sent: Friday, 8 November 2002 14:35
> To: [EMAIL PROTECTED]
> Subject: Copy Records in a ta
Pada Thu, 7 Nov 2002 21:35:00 -0600
"Doug Coning" <[EMAIL PROTECTED]> menulis:
> Hi everyone,
>
> I'm still learning MySQL. I have a database of 600 items. I am still
> adding products. Several of these products are identical in nature, but
> have maybe one or two columns that are different.
Hi everyone,
I'm still learning MySQL. I have a database of 600 items. I am still
adding products. Several of these products are identical in nature, but
have maybe one or two columns that are different. Is there a way to write a
SQL command that selects these items and then inserts them, and
