mysql删数据不删表,mysql – 如何在不删除列名的情况下删除表数据

如何删除表数据,但不删除表列名？

ID | NAME | AGE | ADDRESS | SALARY |

+----+----------+-----+-----------+----------+

| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |

| 2 | Khilan | 25 | Delhi | 1500.00 |

| 3 | kaushik | 23 | Kota | 2000.00 |

| 4 | Chaitali | 25 | Mumbai | 6500.00 |

| 5 | Hardik | 27 | Bhopal | 8500.00 |

| 6 | Komal | 22 | MP | 4500.00 |

| 7 | Muffy | 24 | Indore | 10000.00 |

+----+----------+-----+-----------+----------

我必须删除表的所有内容,但不应删除表列名.

DELETE FROM table_name

WHERE [condition];

ID | NAME | AGE | ADDRESS | SALARY |