import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class bug7754
{
   public static void main(String[] args) throws Exception
   {
      String REPLACE = "REPLACE INTO my_table (balance) SELECT balance FROM my_table2";
      String URL = "jdbc:mysql://localhost/test";
      String USER = "root";
      String PASS = "";
      String DRIVER = "com.mysql.jdbc.Driver";
      
      DriverManager.registerDriver((Driver) Class.forName(DRIVER).newInstance());

            
      // Insert an empty blob.
      Connection con = DriverManager.getConnection(URL, USER, PASS);
      PreparedStatement ps = con.prepareStatement(REPLACE);
//      ps.setString(1, ID);
      boolean result = ps.execute();
      ps.close();
      con.close();
      
   }
}