Question: ddl statements are autocommit in sql?
Answer: Non-autocommit mode enables grouping of multiple data manipulation SQL commands into a single atomic transaction. Most DBMS (e.g. MariaDB) force autocommit for every DDL statement, even in non-autocommit mode. In this case, before each DDL statement, previous DML statements in transaction are autocommitted.