yii_goods_categories 表结构 goods_id int(10) category_id int(10) extend tinyint(1)
sql语句
insert into yii_goods_categories
select goods_id, '91' as `category_id`, '1' as `extend` from yii_goods where goods_sku IN ('860924','860927');
'91' as `category_id` '' `` 的顺序一定不能反了。 记录一下.