![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e263. Deleting All Rows from a Database TableAll the rows in a table can be deleted either by using theTRUNCATE or DELETE SQL statement. TRUNCATE is faster
than DELETE since it does not generate rollback information, does
not fire any delete trigger, and does not record any information.
This example deletes all the rows from a database table called
try { Statement stmt = connection.createStatement(); // Use TRUNCATE String sql = "TRUNCATE my_table"; // Use DELETE sql = "DELETE FROM my_table"; // Execute deletion stmt.executeUpdate(sql); } catch (SQLException e) { }
© 2002 Addison-Wesley. |