Hai to all,
Now i'm trying to export Mysql table to a file By using the
following program...
itz sucessfully compiled... but it throws the above Exception..
Can anyone plzz help me....HTML Code:[CODE]import java.io.*; import java.sql.*; public class ExportData { public static void main(String args[]) { String Driver; Statement stmt; ResultSet rs; Driver = "com.mysql.jdbc.Driver"; Connection con = null; try { Class.forName(Driver); con = DriverManager.getConnection("jdbc:mysql://192.168.0.01/senthil","root",""); if(!con.isClosed()){ System.out.println("Successfully connected to MySQL DataBase \n"); stmt = con.createStatement(); String filename = "C:/2.txt"; String tablename = "employees"; String sql; stmt.executeUpdate("SELECT * INTO OUTFILE \"" + filename + "\" FROM " + tablename); } } catch(Exception e) { System.err.println("Exception: " + e.getMessage()); } finally { try { if(con != null) con.close(); } catch(SQLException e) {} } } }[/CODE]
thanks and regards..
senthil




Reply With Quote