Home >> MySql >> Truncate table in MySql

Truncate table in MySql

Truncate table used to all data is deleted but schema remains, memory released and can not rollback.

Example

TRUNCATE TABLE tablename;

Post Your Comment

Next Questions
Insert query
Select table
Where clause
AND Clause
OR Clause
Update query
Delete query
Like clause
IN clause
Order By
Group By
Distinct keyword
Sorting
Between
Having
Union
Union all
Exits
Not Exits
Any
All
Max
Min
Avg
Count

Copyright ©2022 coderraj.com. All Rights Reserved.