Reply to 'Mysql: Which to use when: drop table, truncate table, delete from table' on stackoverflow:
In addition to the answers above, on Oracle RDBMS, “delete” is a transaction that can be rolled back if you didn’t commit. “Truncate” cannot.
If you enjoyed my content for some reason, I'd love to hear from you! Here are some options:
- You can buy me a coffee!
- You can write a reply on your own site and submit the URL as a webmention via the form below.
- Or you can just contact me!