mysql while ... end while;

CREATE PROCEDURE insdata2()
BEGIN
  DECLARE v1 BIGINT;
  SET v1 = 145389206388152;

  WHILE v1 < 145389206468152 DO
    INSERT INTO mac_addr_itibia_1 set mac=conv(v1, 10, 16), use_status = '0';
    SET v1 = v1 + 1;
  END WHILE;
END;

CALL insdata2();

select count(*) FROM mac_addr_itibia_1;
DELETE FROM mac_addr_itibia_1;

SELECT CAST(0x843B10003DB8 AS SIGNED);