MySQL 5.5

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

select version();

version()

5.5.62

-- MySQL 5.5 made InnoDB the default storage engine
create table t (id int primary key, name varchar(20));
insert into t values (1,'alpha'),(2,'beta');

Records: 2  Duplicates: 0  Warnings: 0

select table_name, engine
from information_schema.tables
where table_name = 't';

table_name
engine

t
InnoDB

select * from t;

id
name

1
alpha

2
beta