On Tue, Dec 15, 2009 at 11:54 AM, Chad Gray <[email protected]> wrote:
> > Is there any easy way to take a row of data from one table and copy it to > another? The tables have the exact same columns, they just have different > table names. > > The tables have many columns so typing out each column in an insert query > will be tedious. > > Any ideas would be appreciated! > Chad > > Quickest way to make a backup of a table is select * into table2 form table1 table2 cannot exist yet. It won't setup your primary keys or constraints but it will dump all the data from table 1 into table 2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
