Command to create mysql table

We can create the mysql database tabel by using the phpmyadmin to check the mysql issues.

1st) Create the normal table with the following query

 CREATE TABLE example (
id INT,
data VARCHAR(100)
);

 

2nd) Create the table to check the storage engine,for example refer to the following mysql query for innodb storage engine.

mysql>  CREATE TABLE example_innodb (
id INT,
data VARCHAR(100)
) TYPE=innodb;