show create table keweitest110\G
*************************** 1. row ***************************
Table: keweitest110
Create Table: CREATE TABLE `keweitest110` (
`id` int(2) NOT NULL,
`salary` decimal(6,2) DEFAULT NULL,
`address` varchar(2) COLLATE utf8_bin DEFAULT NULL,
`risk_rating` tinyint(2) DEFAULT 110,
PRIMARY KEY (`id`),
KEY `salary` (`salary`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin