建表语句
CREATE TABLE table_name (
weeks varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
type varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
cnt_x bigint(11) DEFAULT ‘0’,
avg_x double(11,4) DEFAULT ‘0’,
xxx bigint(10) DEFAULT ‘0’,
ds date DEFAULT NULL,
KEY ds (ds)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci