# DELETE Statement

__*DELETE syntax*__

+ syntax:
```
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)
```
------------------------------------------------------------
Except that there is no [column_list] clause part, the syntax of the other DELETE clauses are very similar to SELECT, essentially finding existing table rows and then deleting them. If you are not familiar with SELECT statements, first return to the preamble course 201.2 Learn SQL from TiDB to learn.