mysql rownum 的实现方法

    xiaoxiao2021-03-25  123

    mysql rownum 的实现方法

    SELECT @rownum := @rownum+1 rownum, id from (   SELECT @rownum := 0, id   FROM t_student   WHERE status = 1   ORDER BY id asc ) as t

    转载请注明原文地址: https://ju.6miu.com/read-11029.html

    最新回复(0)