Truncate Mysql Table

Mysql TRUNCATE TABLE statement allow to delete all data of table. Truncate statement is like a delete record feature without any where clause but truncate statement is automatically reset primary key of table.

Syntax:

Here shows mysql TRUUNCATE TABLE statement stntax. you can use belowe syntax and delete all records of your table.

Example Script :

You can truncate mysql table using above query statement from the phpmyadmin and also you can truncate your mysql table using the php script code. here below show the basic example code of truncate mysql table.