How To Delete All Rows a Table?

Answer 1

If you want to delete all rows from a table, you have two options:

Use the DELETE statement with no WHERE clause.
Use the TRUNCATE TABLE statement.
The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good example of TRUNCATE statement:

SELECT COUNT(*) FROM temp_links;
  COUNT(*)
----------
         3

TRUNCATE TABLE temp_links;
Table truncated.

SELECT COUNT(*) FROM temp_links;
  COUNT(*)
----------
         0