RE: Copy Records in a table...

2002-11-08 Thread Alan McDonald
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

RE: Copy Records in a table...

2002-11-08 Thread Adam Nelson
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

Re: Copy Records in a table...

2002-11-08 Thread David Felio
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

RE: Copy Records in a table...

2002-11-07 Thread Alan McDonald
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

Re: Copy Records in a table...

2002-11-07 Thread Dicky Wahyu Purnomo
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.