Sql truncate table using this statement you can remove all data of rows or column ( complete data ) not table. in this there is no where clause but where clause is available in delete statement.

2..TRUNCATE command TRUNCATE command removes all the records from a table. But this command will not destroy the table's structure. When we use TRUNCATE command on a table its (auto increment) primary ...

This article explains the use and difference of delete, truncate and drop statements of mysql.1. delete : delete command is used to delete all or specific records from mysql table. the records delete ...

The `TRUNCATE` statement removes all data from the table in a non-transactional way. `TRUNCATE` can be thought of as semantically the same as `DROP TABLE` + `CREATE TABLE` with the previous definition ...