truncate in mysqlLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Difference between Delete and Truncate – Drop-Mysql

Delete: ——- 1. Delete operations can be rollback 2. We can use where clause in delete operation 3. Using delete function we can delete row by row 4. It will not reset the autoincrement field- suppose your last record id of autoincrement field is 4, then after delete operaion next entry will be starting with… Read More »

Difference between TRUNCATE,DELETE and DROP commands

1)DELETE-Delete command is using to remove a rows from a table. “Where” clause is used to remove some rows. if no “where” condition specified all rows will be removed. After performing a DELETE operation you need to “commit” or “Rollback” the transaction to make the change permanent or undo it. 2)TRUNCATE- “truncate” removes all rows… Read More »