I divided table on two parts, but MySQL scanning full table

Hello
There is a table, into the table is a field id
It is expected that, in this table awaken 1 billion REC.
I want to divide (through partition) this table so that:
Everi part contained one million REC.
I make this so:

PARTITION BY RANGE(id) (
PARTITION p_1 VALUES LESS THAN(1000000),
PARTITION p_2 VALUES LESS THAN(2000000),
PARTITION p_3 VALUES LESS THAN(3000000),
.................
...........


But, I have done this 1000 times by hand.
Question: This is single variant?
There is no way to do this automatically?
Thanks

You could write a script in your favorite scripting language that outputs the SQL statements instead of writing each by hand.

Also just curious how far away in time are you planning to reach 1,000,000,000 records? Because you don't have to create all partitions right now but instead as you go along and I've heard to many times that -"we need to plan for 500 million rows" and they never reach even 1 million.

Also how large is one record? Do you really need to cap it at 1 million, can't you allow 10 million instead.

All clearly, thanks so much for answer

Hello.
I write this query:

CREATE TABLE qwe(
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
PRIMARY KEY(id)
)

PARTITION BY RANGE(id) (
PARTITION p_1 VALUES LESS THAN(50000),
PARTITION p_2 VALUES LESS THAN(MAXVALUE)
)

After, I insert into the table 100 000 record.
After, I make query with EXPLAIN ()


$res = mysqli_query($db, "EXPLAIN PARTITIONS SELECT name FROM qwe WHERE id > 70000");
while($row = mysqli_fetch_assoc($res)) {
echo $row["partitions"].' , '.$row["rows"].' <br>';
}

resultat:
p_2 , 100000

rezultat from "rows" is 100000.
Question: the table is divided the two parts, but MySQL scanning full table, why?
Please answer me if my question is clearly, this is very Important for me.

No the single "p_2" means that it is only using the p_2 partition.

While the rows value is the total number of rows in the _table_ and has nothing to do with how many rows that has been involved in the execution of the query.