aspose 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 Spring in Action this week in the Spring 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)