!連番
  SELECT
    @num := 0 AS generate_no 
  UNION ALL 
  SELECT
    @num := @num + 1 
  FROM
    information_schema.columns 
  LIMIT
    10


!カレンダー
  SELECT
    @num := DATE_ADD(CURRENT_DATE, INTERVAL - 18 MONTH) AS generate_no 
  UNION ALL 
  SELECT
    @num := DATE_ADD(@num, INTERVAL + 1 DAY) 
  FROM
    information_schema.columns 
  WHERE
    @num < CURRENT_DATE


{{category2 データベース,MySQL}}