File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Better way to update a record from one table with column values from another (SOLVED)