Loading a Flat File to a MySQL Table, file is terminated by \r\n, use this statement : MySQL « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. MySQL

Loading a Flat File to a MySQL Table, file is terminated by \r\n, use this statement

   

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

public class Main {
  public static void main(String[] argv) throws Exception {
    Connection connection = DriverManager.getConnection(url, username, password);
    Statement stmt = connection.createStatement();
    
    // Load the data
    String filename = "c:/infile.txt";
    String tablename = "mysql_2_table";
    stmt.executeUpdate("LOAD DATA INFILE \"" + filename + "\" INTO TABLE " + tablename);

    // file is terminated by \r\n, use this statement
    stmt.executeUpdate("LOAD DATA INFILE \"" + filename + "\" INTO TABLE "
                       + tablename + " LINES TERMINATED BY '\\r\\n'");

  }
}

   
    
    
  

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