This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 483

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Better way to update a record from one table with column values from another (SOLVED)
 
Similar Threads
Castor -- using GROUP BY to retrieve data from database
Help with SQL
Castor -- using GROUP BY to retrieve data from database
Castor -- using GROUP BY to retrieve data from database
Groupby Question