INSERT INTO tbl2 (col1, col2, etc) SELECT col1, col2, etc FROM tbl1 Should copy everything from tbl1 to tbl2. This presumes that tbl2 is empty.
Cheers, Judah daniel kessler 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:287527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
