mysql> show create table data; +-------+-----------------------------------------------------+ | Table | Create Table | +-------+-----------------------------------------------------+ | data | CREATE TABLE `data` ( `id` int(11) NOT NULL auto_increment, `key` varchar(255) default NULL, `value` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | +-------+-----------------------------------------------------+ 1 row in set (0.00 sec)