# DELETE 语句

__*DELETE 语法*__

+ 语法:
```12
DELETE FROM table_name
  [WHERE condition]
  [ORDER BY ...]
  [LIMIT row_count];

tidb> SELECT count(*) FROM universe.planets;
+----------+
| count(*) |
+----------+
|       10 |
+----------+

tidb> DELETE FROM universe.planets;
Query OK, 10 rows affected (0.01 sec)
```
----------------------------------
除了没有 [column_list] 子句部分,DELETE 的其他子句语法和 SELECT 非常类似,本质上是找到已存在的表行,然后删除它们。如果你对 SELECT 语句不熟悉,请首先返回前导课程 201.2 Learn SQL from TiDB 进行学习。