Is it possible to get a detailed explanation of the answer here?
MySQL states that TRUNCATE is a DDL operation and that it’s not possible to rollback the DDL operations.
So how exactly is it possible to rollback the TRUNCATE there?
I’ve also read that TRUNCATE makes an autocommit by itself.
And you mention a “log” which is used - it is strange, which log are we talking about, because there was no mention of logging in transaction lesson at all…
Thanks!
Course: https://www.educative.io/collection/5352985413550080/6335716377231360
Lesson: https://www.educative.io/collection/page/5352985413550080/6335716377231360/4565491877150720