Adding 2000 autocomplete field records to an existing mysql table

Question

I have a table named users

fields:

ID INT
First_name VARCHAR
Second_name VARCHAR
National_ID INT

The ID field is an AUTO_INCREMENT.

I need to AUTO_INCREMENT the first 2000 users with just the ID and the other fields remain blank,so that the new users will start at 2001.

Kindly assist.

possible duplicate of [Change auto increment starting number?](http://stackoverflow.com/questions/970597/change-auto-increment-starting-number) — IROEGBU, May 26 '14 at 07:32
DO NOT USE AUTO_INCREMENT FOR THIS!!! Despite its name, that's not what it's for! — Strawberry, May 26 '14 at 08:57
setting the start value of AUTO_INCREMENT to 2001, solves half the problem, now how do i populate the first 2000 fields with just the ID field? — tairus, May 26 '14 at 10:31

h.s.o.b.s · Accepted Answer · 2014-05-26T13:45:45.937

0

It's called auto increment, your ID column must be set to auto increment.

ALTER TABLE users AUTO_INCREMENT=2001;

Update

If you wish to actually create those rows (not just set the auto increment value) you can use PHP for this:

for($i=1; $i<=2000; $i++)
{
    $query = 'INSERT INTO users (id) VALUES ('.$i.')';
    //execute this query using your desired PDO or sql extension
}

edited May 26 '14 at 13:45

answered May 26 '14 at 07:28

h.s.o.b.s

1 Answers1