增加一个字段从1开始自增

SELECT @numlist:=0;
update t_article a, (SELECT @orderItem:=0) b set s_id = @numlist + (@orderItem:=@orderItem+1);