I have a "copy" button in my jsp page.
When I click on copy button , I want to copy data from few tables to other few tables in the same database schema.
source table name and destination table name are different.
source column name and destination column name are different.
My database mysql 5 , Jboss 5 server , JDK 1.5
Whats the best approach I can think of ?