Free since 2005 · No login required
AT

Academic Tutorials

Learn at your own pace

site-mobile-top-banner · 320x50

What is difference between delete and truncate statements of MySQL?

DELETE FROM table_name WHERE 1>0;
TRUNCATE funtionality is an Oracle SQL extension adopted in MySQL.