直接上例子:
CREATE TABLE `t_biological_dic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`BM` varchar(42) COLLATE utf8_unicode_ci DEFAULT NULL,
`FL_BM` varchar(42) COLLATE utf8_unicode_ci DEFAULT NULL,
`MC` varchar(600) COLLATE utf8_unicode_ci DEFAULT NULL,
`XH` decimal(22,0) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `test`.`t_biological_dic` (`id`, `BM`, `FL_BM`, `MC`, `XH`) VALUES ('1', 'BM10000', NULL, '生物', '1'); #生物
INSERT INTO `test`.`t_biological_dic` (`id`, `BM`, `FL_BM`