MySQL兑现rownum Home » IDC云服务 » MySQL兑现rownum MySQL实现rownum SELECT @rownum:=@rownum+1 AS rownum, frutas.* FROM (SELECT @rownum:=0) r, frutas;