Results 1 to 2 of 2
Thread: deleting records in a db
- 11-08-2011, 05:43 PM #1
Senior Member
- Join Date
- Feb 2011
- Posts
- 231
- Rep Power
- 3
deleting records in a db
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 1Java Code: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); } } }
- 11-08-2011, 07:16 PM #2
Moderator
- Join Date
- Jul 2010
- Location
- California
- Posts
- 1,605
- Rep Power
- 5
Re: deleting records in a db
See the following link for the proper syntax of an SQL delete statement
SQL DELETE Statement
Note the lack of a wildcard in the examples
Similar Threads
-
Throttling records
By jitman in forum New To JavaReplies: 0Last Post: 03-11-2010, 06:18 PM -
Moving records from one Arraylist to another?
By JavaStudent23 in forum New To JavaReplies: 4Last Post: 02-17-2010, 09:52 PM -
insert records
By rudravaram in forum JDBCReplies: 3Last Post: 01-03-2010, 05:54 PM -
How to delete the records
By kiran kumar in forum Java ServletReplies: 6Last Post: 11-09-2008, 01:16 PM -
Deleting records from database table using PreparedStatement
By Java Tip in forum Java TipReplies: 0Last Post: 02-09-2008, 08:31 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks