How about INSERT INTO new_table SELECT * FROM old_table
On 8/31/07, daniel kessler <[EMAIL PROTECTED]> wrote: > I have a table and I'd like to duplicate all of it's data to another table. > I've set the second table to have the same structure. How do I go about > transferring that data through SQL? It'll be a one-time transfer. > I'd like to do the whole table at once, but if I have to do field by field, > then that's okay too. > > Here's my attempt at doing the first field, which failed: > update timesheets_tmp > set date_added = > ( > select date_added > from timesheets > ) > > It executes fine but timesheets_tmp isn't updated. > > thank you. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4