關于mysql插入語句中變量使用的問題,請高手做答
declare @i int ;beginset @i=1 ;while @i<800begin insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,1,a,0);insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,2,b,0);insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,3,c,0);insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,4,d,0);insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,5,e,0);insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,6,f,0);insert into ecs_goods_attr(goods_id,attr_id,attr_value,attr_price) value(@i,9,g,0);set @i=@i+1 ;end ; end;這樣再試試吧。