摘要: CREATE TABLE `result` (`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,`thetime` CHAR(100) , `category` CHAR(100) , `weight` decimal(24,4), PRIMARY KEY 阅读全文
posted @ 2017-08-01 18:04 残阳飞雪 阅读(255) 评论(0) 推荐(0)
摘要: CREATE TABLE `category` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `editdate` char(20) NOT NULL DEFAULT "20170622", `number` CHAR(100) NOT NULL DEFAULT "spell", `category` CHAR(100) NOT NULL... 阅读全文
posted @ 2017-08-01 16:48 残阳飞雪 阅读(308) 评论(0) 推荐(0)
摘要: CREATE table layer(id INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, words VARCHAR(500), value decimal(10,7), PRIMARY KEY(id) ) DEFAULT CHARSET=utf8; ALTER TABLE `layer` ADD INDEX(`words`) /** *... 阅读全文
posted @ 2017-08-01 16:44 残阳飞雪 阅读(388) 评论(0) 推荐(0)
摘要: CREATE TABLE `middle` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `innserSessionid` VARCHAR(250), `times` VARCHAR(250), `number` VARCHAR(250), `category` VARCHAR(250), `svalue` DECIMAL(32,7), `w... 阅读全文
posted @ 2017-08-01 16:43 残阳飞雪 阅读(295) 评论(0) 推荐(0)
摘要: CREATE TABLE titlesplit(id INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, innserSessionid VARCHAR(50), times VARCHAR(50), channelType VARCHAR(50), sourcetitle VARCHAR(500), title VARCHAR(500), words VARC... 阅读全文
posted @ 2017-08-01 16:41 残阳飞雪 阅读(199) 评论(0) 推荐(0)