ir 提示补全 sql

autocomplete.sql

CREATE TABLE `search_info_new` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `query` varchar(256) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `created_by` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '创建此记录的人',
  `created` datetime DEFAULT NULL COMMENT '创建此记录的时间',
  PRIMARY KEY (`id`),
  KEY `idx_query` (`query`(255)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3407821 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


insert into search_info_new(query, created_by, created) select memo, user_nick, created from search_info where action='search_global' and CHAR_LENGTH(memo) < 128

select query, count(1) as count from search_info_new where query LIKE "产%" group by query order by count desc limit 10