 |
|
 |
| |
Developer on focus
Anton Zamov is a dipl. engineer with more than 6 years of active professional
experience and many awards ...
read more>>
|
|
 |
 |
 |
|
|
|
|
| |
|
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:\\\\\\\\temp\\\\\\\\infile.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 \\r\\n, use this statement
stmt.executeUpdate("LOAD DATA INFILE \\"" + filename + "\\" INTO TABLE "
+ tablename + " LINES TERMINATED BY '\\\\r\\\\n'");
} catch (SQLException e) {
}
|
About the author of this programming example or tutorial:
Anton Zamov is a software engineer with more than6 years
of active experience in web and software development and design.
Anton Zamov has extensive experience and broad knowledgebase
in C# and JAVA programming and has created a lot of
running e-commerce systems, portals and content management
systems using PHP and other web development technologies.
For more information about Anton Zamov, you may visit the personal web site of
Anton Zamov.
|
|
|
|
|
|
|
|
