SELECT @numlist:=0; update t_article a, (SELECT @orderItem:=0) b set s_id = @numlist + (@orderItem:=@orderItem+1);
增加一个字段从1开始自增
随笔看心情
SELECT @numlist:=0; update t_article a, (SELECT @orderItem:=0) b set s_id = @numlist + (@orderItem:=@orderItem+1);