This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Customer Requirements for Developers and have Marcho Behler on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Better way to update a record from one table with column values from another (SOLVED) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Better way to update a record from one table with column values from another (SOLVED)" Watch "Better way to update a record from one table with column values from another (SOLVED)" New topic
Author

Better way to update a record from one table with column values from another (SOLVED)

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 484

edit - nevermind, my whole reasoning is flawed here...

I am just wanting to basically copy/paste 2 records from one table to another. The record has something like 40 columns.

The best way I know to do this is as follows:


where I will need to write out all 40 column mappings. There has to be an easy way to write this statement (or not?)

Thanks


True wisdom is in knowing you know nothing - Socrates
 
Don't get me started about those stupid light bulbs.
 
subject: Better way to update a record from one table with column values from another (SOLVED)
 
It's not a secret anymore!