a digital blog

Category: Tricks

MySql-difference-between-Drop,-Truncate-and-Delete

MySql, Tricks

MySql difference between DROP, TRUNCATE and DELETE

In MySql the difference between DROP, TRUNCATE and DELETE is one of the most common interview question. Thus I have to  explain the differences between DROP, TRUNCATE and DELETE statements of MySQL. DROP:-  Drop command will remove entire table from the database. Drop opration can not be rolled back. TRUNCATE :- TRUNCATE is a DML command TRUNCATE removes all rows from a table [...]

Read More »

Copyright © 91 Web Lessons - a digital blog