Exporting a MySQL Table to a Flat File : MySQL « Database SQL JDBC « Java






Exporting a MySQL Table to a Flat File

   

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

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "org.gjt.mm.mysql.Driver";
    Class.forName(driverName);

    String serverName = "localhost";
    String mydatabase = "mydatabase";
    String url = "jdbc:mysql://" + serverName + "/" + mydatabase;
    String username = "username";
    String password = "password";
    Connection connection = DriverManager.getConnection(url, username, password);
    
    Statement stmt = connection.createStatement();
    
    String filename = "c:/outfile.txt";
    String tablename = "mysql_2_table";
    stmt.executeUpdate("SELECT * INTO OUTFILE \"" + filename + "\" FROM " + tablename);

  }
}

   
    
    
  








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.Copy data from one table to another in a database
27.MySQL Error code and message