• 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) {
}
|
Still have questions?
Ask your question on TechOnlineHelp.com
or find more examples on www.netartmedia.net/examples
If this example was useful for you, please support my company and click Like on the button below.
Thank you very much!
|

|
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
Pharmacy System, software for running online pharmacies
|