mysql에서 row 생성

by 지기 · 2015-09-24

-- 지정한 숫자만큼 행이 생성됨
SELECT @curRow := @curRow + 1 AS row_number
  FROM table_name INNER JOIN (SELECT @curRow := 0) A
 WHERE @curRow < 10;