anton zamov it expert logo    

home page latest news web development curriculum vitae scripts contact me


  • Curriculum Vitae (CV)
  • Major web solutions
  • Web design projects
  • Software solutions


  • C# (Microsoft .NET)
  • JAVA
  • Dynamic HTML
  • PHP & MySQL
  • ASP.NET - C# & VB.NET
  • Perl & CGI
  • C | C++
  • Vector Markup Language
  • SMIL
  • Assembler
  • Databases
  • Wap Development
  • Web site promotion
  • Web Marketing




How to load a flat file in a MySQL database?

(JAVA free example written by Anton Zamov.)


How to load a flat file in a MySQL database?

The default format of a file to load into a MySQL table is as follows: the fields must be separated by tabs, the input lines terminated by 'n', and backslashes(), newlines (n), and tabs (t) escaped by a backslash. The MySQL documentation explains how to change these defaults.
This example loads a flat file called infile.txt to a MySQL table named mysql_2_table with an INT and a VARCHAR(20) column.

try {
// Create the statement
Statement stmt = connection.createStatement();

// Load the data
String filename = "c:tempinfile.txt";
String tablename = "mysql_2_table";
stmt.executeUpdate("LOAD DATA INFILE "" + filename + "" INTO TABLE " + tablename);

// If the file is comma-separated, use this statement
stmt.executeUpdate("LOAD DATA INFILE "" + filename + "" INTO TABLE "
+ tablename + " FIELDS TERMINATED BY ','");

// If the file is terminated by rn, use this statement
stmt.executeUpdate("LOAD DATA INFILE "" + filename + "" INTO TABLE "
+ tablename + " LINES TERMINATED BY 'rn'");
} catch (SQLException e) {
}










Jobs Portal, poweful jobs board software

PHP Mall, multi vendors mall website software

Car Portal, php script for auto classifieds websites

NetArt Media, software products and services

Real Estate Portal, web software for real estate portals

Blog System, multi user blog hosting script

PHP Store, powerful e-commerce system written in PHP


C# (Microsoft .NET) | JAVA | Dynamic HTML | PHP & MySQL | Perl & CGI | C | C++ | Vector Markup Language
SMIL | Assembler | Databases | Wap Development | Web site promotion | Web Marketing

Copyright © Anton Zamov 1998 - 2023