MySQL查询某个记录行号

查询test表中id为16的记录是第几行的两个方法 MySQL mysql select count(*) from test where id = (select id from test where id=16); +----------+| count(*) |+----------+| 1 |+----------+1 row in set (0.00 sec) mysql select count(*) from test wher

mysql> select count(*)  from test  where id 
        		            	
            	            	
            	            	
            	
mysql> select count(*)  from test  where id