DROP TABLE IF EXISTS `ecs_link_goods`;
CREATE TABLE `ecs_link_goods` (
`goods_id` mediumint(8) unsigned NOT NULL default ‘0’,
`link_goods_id` mediumint(8) unsigned NOT NULL default ‘0’,
`is_double` tinyint(1) unsigned NOT NULL default ‘0’,
`admin_id` tinyint(3) unsigned NOT NULL default ‘0’,
PRIMARY KEY (`goods_id`,`link_goods_id`,`admin_id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
insert into ecs_link_goods (goods_id,link_goods_id,is_double,admin_id)
SELECT a.goods_id,b.goods_id,0,1
FROM ecs_goods a,ecs_goods b
WHERE
a.goods_id+5>b.goods_id and a.goods_id-5b.goods_id