CREATE TABLE t (a SERIAL) ENGINE=InnoDB;
connect  dml,localhost,root;
select * from t;
a
connection default;
TRUNCATE TABLE t;
disconnect dml;
DROP TABLE t;