mysql 伪列_Mysql中的伪列

Oracle中有个RowNum,Mysql中呢？今天遇到一个没有主键id的表，着实令人郁闷，只好动用伪列

DELETE FROM

hh

WHERE user_age IN(

SELECT tab.user_age FROM

(SELECT fhtab.user_age , COUNT(*) AS COUNT FROM

(SELECT @rownum:=@rownum+1 rownum,htab.* FROM

(SELECT @rownum:=0,hh.* FROM hh) htab) fhtab

GROUP BY fhtab.user_age HAVING COUNT > 1 ORDER BY fhtab.user_age) tab)

AND

这样肯定是不正确的，因为hh表中没有 rownum这个字段呀，，但是辛苦一番，没有功劳得有苦劳，就显示一下mysql中伪列的创建

rownum NOT IN

(SELECT mhtab.rownum FROM (SELECT MIN(fhtab.rownum) AS rownum,COUNT(*) AS COUNT FROM

(SELECT @rownum:=@rownum+1 rownum,htab.* FROM

(SELECT @rownum:=0,hh.* FROM hh) htab) fhtab

GROUP BY fhtab.user_age HAVING COUNT > 1 ORDER BY fhtab.user_age) mhtab)