> I tried this and doesn't work unforunately. I get "ERROR: Duplicate > entry..." that occurs when copying from the temporary table back into > the original table.
> 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 >> create temporary table t1 select ... from orig_table where ... >> insert into orig_table select ... from t1 Just insert null instead of the primary key: create temporary table t1 select ... from orig_table where ... insert into orig_table select null, your_column1, your_column2... from t1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
