You would need to define and execute a stored procedure (assuming you want to do this on the server, not the client).
If
id
is
AUTOINCREMENT
CREATE PROCEDURE initiaize_id()
BEGIN
DECLARE v1 INT DEFAULT 0;
WHILE v1 < 10000 0 DO
INSERT INTO MyTable (id) VALUES (null);
SET v1 = v1 + 1;
END WHILE;
END;
otherwise
CREATE PROCEDURE initiaize_id()
BEGIN
DECLARE v1 INT DEFAULT 0;
WHILE v1 < 10000 0 DO
INSERT INTO MyTable (id) VALUES (v1);
SET v1 = v1 + 1;
END WHILE;
END;