Difference between truncate and delete in mysql ?
Truncate is faster than delete. Truncate deletes all records from table and cannot retrieved where delete only delete selected record and can be retrieve when you rollack.
Showing posts with label Comparison of truncate and delete in mysql. Show all posts
Showing posts with label Comparison of truncate and delete in mysql. Show all posts
Saturday, 21 June 2014
Difference between truncate and delete in mysql ?
Difference between truncate and delete in mysql ?
Truncate is faster than delete. Truncate deletes all records from table and cannot retrieved where delete only delete selected record and can be retrieve when you rollack.
Subscribe to:
Posts (Atom)