JAVA free example : How to export a MySQL Table to a Flat File? tutorial sample code

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 export a MySQL Table to a Flat File?

(JAVA free example written by Anton Zamov.)

How to export a MySQL Table to a Flat File?

The default format of a file exported from MySQL is as follows: the fields are separated by tabs, the lines terminated by 'n', and backslashes(), newlines (n), and tabs (t) escaped by a backslash. NULL is exported as N.
This example exports the data in a table called mysql_table2 to a file named outfile.txt.

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

// Export the data
String filename = "c:tempoutfile.txt";
String tablename = "mysql_2_table";
stmt.executeUpdate("SELECT * INTO OUTFILE "" + filename + "" FROM " + tablename);
} 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