Collections:
Deleting All Rows in a Table in MySQL
How To Delete All Rows in a Table in MySQL?
✍: FYIcenter.com
If you want to delete all rows from a table, you have two options:
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)
⇒ SELECT Query Statements with GROUP BY in MySQL
⇐ Deleting Multiple Rows from a Table in MySQL
2018-01-08, 1376🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...