![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e292. Loading a Flat File to a MySQL TableThe 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 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) { }An example of the contents of infile.txt (\t represents an invisible tab character): 123\tString1 234\tString2
e294. Loading a Flat File to an Oracle Table e295. Exporting a MySQL Table to a Flat File © 2002 Addison-Wesley. |