Different tables present in MySQL

Question

Hi friends,
                 I want to know that what are the different tables present in MySQL, which type of
table is generated when we are creating a table in the following syntax:
create table employee (eno int(2),ename varchar(10)) ?

Thanks