Deleting All Rows in a Table in MySQL

Q

How To Delete All Rows in a Table in MySQL?

✍: 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)

 

⇒INSERT, UPDATE and DELETE Statements in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 182👍, 0💬

General MySQL Oracle SQL Server