Ari Denison wrote:
I have a need to duplicate individual records in a table with a large
number of fields.
This is not part of a backup or restore process. I simply need to be
able to duplicate a record or two on occasion.
Is there an efficient way to do this?
I obviously don't want to duplicate keyfields, just the data.
create temporary table t1 select ... from orig_table where ...
insert into orig_table select ... from t1
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]