e263. deleting all rows from a database table.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 20 行

All the rows in a table can be deleted either by using the TRUNCATE 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 my_table. 

    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) {
    }

 Related Examples