[GENERAL] Copy row from table to table

2004-12-14 Thread Kall, Bruce A.
What is the easiest way to copy a particular row from one table to another (assuming all the columns are exactly the same). I want to maintain a table ('backup_table') that has rows I have (or will be) deleting from my 'original_table'. (Both tables have the same 68 columns). I've tried INSERT

Re: [GENERAL] Copy row from table to table

2004-12-14 Thread Michael Fuhr
On Tue, Dec 14, 2004 at 11:48:21AM -0600, Kall, Bruce A. wrote: What is the easiest way to copy a particular row from one table to another (assuming all the columns are exactly the same). I want to maintain a table ('backup_table') that has rows I have (or will be) deleting from my

Re: [GENERAL] Copy row from table to table

2004-12-14 Thread Doug Bloebaum
Michael Fuhr [EMAIL PROTECTED] 12/14/04 1:45 PM On Tue, Dec 14, 2004 at 11:48:21AM -0600, Kall, Bruce A. wrote: What is the easiest way to copy a particular row from one table to another (assuming all the columns are exactly the same). I want to maintain a table ('backup_table') that has