Oracle to MySQL syntax question

INSERT INTO VOUCHER (VOUCHER_NUMBER, BOOK_ID, DENOMINATION)
SELECT a.a1, b.ID, b.DENOMINATION FROM
(SELECT rownum a1 FROM dual CONNECT BY rownum <= 10000000) a, BOOK b
where a.a1 between b.START_NUMBER and b.START_NUMBER+b.UNITS-1;

for 1 to BOOK.units loop

  INSERT INTO VOUCHER (
      -- VOUCHER_NUMBER handled by auto-increment
      BOOK_ID
    , DENOMINATION
  )
  SELECT
      b.ID
    , b.DENOMINATION
  FROM BOOK b
  WHERE b.ID = [book ID];

end loop