If you want to remove all data from a table, type TRUNCATE TABLE table_name; then, it will permanently delete all data from the table, but the structure will remain.
Syntax:
TRUNCATE TABLE table_name;
If you want to remove all data from a table, type TRUNCATE TABLE table_name; then, it will permanently delete all data from the table, but the structure will remain.
Syntax:
TRUNCATE TABLE table_name;