Is there a way to do this, to copy a single record, without moving the primary key into the temporary table so I can avoid this error?
Ari
On Feb 17, 2004, at 7:13 PM, Sasha Pachev wrote:
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]
Ari Denison Owner, Pixenter INC Lead Developer, Nu-World Communications [EMAIL PROTECTED] (541) 513-1889 stonecrusade (aim) Eugene, Oregon, USA
########################################