MySQL Truncate Table – Truncating a table means only the data of the table will be deleted and the table would still exist even after truncate.
Syntax to truncate a table:
truncate table table_name;
e.g. Suppose a table Address has to be truncated, then the data of the table Address will get deleted and the table would still exist.
truncate table Address;