Answers for "mysql row generator from 1 to 100"

mysql row generator

SELECT  @curRow := @curRow + 1 AS row_number
FROM    sometable 
JOIN    (SELECT @curRow := 0) r
WHERE   @curRow<100;

Posted by: Guest on July-09-2020

Code answers related to "mysql row generator from 1 to 100"