How To Delete All Rows a Table

Q

How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements

✍: FYIcenter.com

A

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:

mysql> SELECT COUNT(*) FROM fyi_links;
+----------+
| COUNT(*) |
+----------+
|        5 |
+----------+
1 row in set (0.08 sec)

mysql> TRUNCATE TABLE fyi_links;
Query OK, 0 rows affected (0.02 sec)

mysql> SELECT COUNT(*) FROM fyi_links;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

2007-05-11, 5792👍, 0💬