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,

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

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

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 the same table except for the unique ID. Is there some

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 do