Tag Archives: delete and drop command in mysql

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 »