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/my***********...ie.nctu.edu.tw