i am trying to delete all records locally on my db. here is my code:
I get this error: java.sql.SQLException: [MySQL][ODBC 5.1 Driver][mysqld-5.5.17]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM members' at line 1Code:import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class DeleteAllDBRecords {
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dataSourceName = "first test";
String dbUrl = "jdbc:odbc:" + dataSourceName;
Connection con = DriverManager.getConnection(dbUrl, "", "");
Statement s = con.createStatement();
s.execute("DELETE * FROM members");
s.close();
con.close();
} catch (Exception e) {
System.out.println(e);
}
}
}
