mysql> show create table t1 ;
+-------+--------------------------------------------+
| Table | Create Table                                                                                                                 |
+-------+--------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `a` varchar(100) default 'TEST TABLE',
  `b` int(11) default '10'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+-------------------------------------------+