Roolback in Mysql 5.7 Workbench does not work! Help

Question

Hello guys okay ? I’m new to Mysql, I would like to ask a question.

I am using a command that is not DML.

but when I give roolback, the error occurs below. Is it some configuration

permission in Workbench , type this auto commit there?

(wampserver use)

Answer 1

You are probably using tables in the format Myisam that does not support transactions.

Instead use table in format Innodb.

How to create tables in this format:

CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB;

It is also possible to change this information in the table operation option:

Answer 2

As our friend up there said, roolback does not work in Myisan . you have to create table for innodb