MariaDB 10.4

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

select version();

version()

10.4.13-MariaDB

create table tablename (id integer not null primary key auto_increment);
create table tablename2 (id integer not null primary key auto_increment);
show create table tablename;

Table
Create Table

tablename
CREATE TABLE `tablename` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

show create table tablename2;

Table
Create Table

tablename2
CREATE TABLE `tablename2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1