mysql> show create table employee; +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | employee | CREATE TABLE `employee` ( `name` varchar(30) default NULL, `address` varchar(50) default NULL, `email` varchar(50) default NULL, `phone` int(12) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)