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, but it's not very efficient way to do it (in my opinion) as when I modify the table (add or remove columns), I should modify also all queries.
Any help is appreciated. Thanks, Ville -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
