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
Is the implementation of this different than the docs say? According to
the manual, I didn't think this would work:
"* The target table of the INSERT statement cannot appear in the FROM
clause of the SELECT part of the query because it's forbidden in ANSI
SQL to SELECT from the same table into
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 table...
>
>
> Hi eve
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.