SET @num = 0;
UPDATE n_bookinfo SET number = (@num := @num + 1) WHERE bid = 8

以下是查询显示行号

SELECT @rowno:=@rowno + 1 AS rowno,a.bid FROM n_bookinfo a ,(SELECT @rowno:=0) b WHERE a.bid =8