How to completely empty Truncate MySQL table in phpmyadmin

How to delete all records from MySQL table in phpmyadmin.

Truncate MySQL command is applied to erase all the elements of tables like all the records. This command is used with table name with specific database name. This command delete all the table records and make the table into by-default stage just like as after created time. After emptying the MySQL database table it will remove rows + columns all records.

On phpmyadmin's MySQL server you can truncate table by selecting Empty option on it. The step by step guide to delete records from MySQL database table.

Erasing all table records with one click using phpmyadmin in xampp.

1. First start apace & MySQL server from phpmyadmin control panel.

2. Visit localhost/phpmyadmin on your web browser.

3. Now select your Database >> Select Table.

4. Click on Empty button which is shows at the front of table name.

5. Now your will show a alert message " You are about to TRUNCATE a complete table ! Do you really want to execute  TRUNCATE tableName."