MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.30


CREATE TABLE `test` (
  `myid` INT UNSIGNED AUTO_INCREMENT NOT NULL,
  `f1` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY(`myid`)
) ENGINE = InnoDB;
insert into `test` (`myid`, `f1`)
values (1, 'A');
ANALYZE TABLE test


Table
Op
Msg_type
Msg_text


fiddle.test
analyze
status
OK


ROLLBACK;
select * from `test`;


myid
f1


1
A