I did this ..
String filename = "tempoutfile.txt";
String tablename = "table1";
try{
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Test","root","");
Statement s=con.createStatement();
ResultSet r=s.executeQuery("SELECT * INTO OUTFILE '"+ filename + "' FROM " + tablename);
}catch(SQLException se){System.out.println(se.getMessage());}
But I can't find the file that is created!!
When I run the query in WAMP mysql console , it creates the out file in wamp\mysql\data . But not in previous case.
Where is this file created?