zencart 相关商品:
insert into products_xsell (products_id,xsell_id,sort_order)
SELECT a.products_id,b.products_id,1
FROM products a ,products b
WHERE
a.products_id+6>=b.products_id and a.products_id-6b.products_id;
清空
delete from products_xsell;
—————————————————————————————————————————————————————
insert into products_xsell (products_id,xsell_id,sort_order)
SELECT a.products_id,b.products_id,1
FROM mallproducts a ,mallproducts b
WHERE
a.products_id+6>=b.products_id and a.products_id-6b.products_id
Vivian 0:10:06
insert into products_xsell (products_id,xsell_id,sort_order)
SELECT a.products_id,b.products_id,1
FROM mallproducts a ,mallproducts b
WHERE
a.products_id+6>=b.products_id and a.products_id-6b.products_id