Copy data from one table to another in a database : MySQL « Database SQL JDBC « Java

Copy data from one table to another in a database


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

public class Main {
  public static void main(String[] args) throws Exception {
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "jdbc4";
    String driver = "com.mysql.jdbc.Driver";
    String userName = "root";
    String password = "root";


    Connection conn = DriverManager.getConnection(url + dbName, userName, password);
    Statement st = conn.createStatement();

    int rows = st.executeUpdate("INSERT INTO Copyemployee SELECT * FROM employee");
    if (rows == 0) {
      System.out.println("Don't add any row!");
    } else {
      System.out.println(rows + " row(s)affected.");


Related examples in the same category

1.Creating connection to the MySQL database
2.Creating a Database in MySQL
3.Creating a MySQL Database Table to store Java Types
4.JDBC Mysql Connection String
5.Inserting values in MySQL database table
6.Use Oracle DataSource To Store MySql Connection
7.Create Database for MySQL
8.Test MySQL JDBC Driver Installation
9.Create table for mysql database
10.Setup mysql datasource
11.Access MySQL Database: open connection, create table, insert and retrieve
12.Count rows in MySQL
13.Demo ResultSet for MySQL
14.Create Table With All Data Types In MySQL
15.Insert text file into MySQL
16.Read a Clob object from MySQL
17.How to serialize/de-serialize a Java object to the MySQL database.
18.Check JDBC Installation for MySQL
19.Demo MySql Transaction
20.Retrieve auto-generated keys
21.Move to absolute or relative row
22.Commit or rollback transaction in JDBC
23.Issue 'create database' command ny using Statement
24.Loading a Flat File to a MySQL Table, file is comma-separated
25.Loading a Flat File to a MySQL Table, file is terminated by \r\n, use this statement
26.Exporting a MySQL Table to a Flat File
27.MySQL Error code and message