Exception: Can not issue SELECT via executeUpdate!

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..

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]

---

Can anyone plzz help me....

thanks and regards..
senthil

The exception says it all. You cannot issue SELECT statements with executeUpdate(). Use executeQuery() instead.