Copying a row

Hi everyone, Is there any easy way to duplicate a row in a table with auto increment column, that shouldn't of course be copied. I tried a query "NSERT INTO table SELECT * FROM table" but it caused an error due to the auto increment column. I succeeded with listing all required fields in the query

Re: copying a row

On Thu, Jan 30, 2003 at 04:13:17PM +0100, W. Enserink wrote: > Hi all, > > > Im in need of some tps. > > I want to copy a row in a table to a new row in the same table except for > the unique ID. Is there some mysql statement for this? Dear Wilbert, INSERT ... SELECT almost allows you to d

Re: copying a row

Hi - Original Message - From: "W. Enserink" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 4:34 PM Subject: copying a row > Hi all, > > > Im in need of some tps. > > I want to copy a row in a table to a new row in t

copying a row

Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http

copying a row

Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 ht