INSERT INTO newtable  SELECT * FROM oldtable WHERE ID < 1000000;