auto increment 2 fields

[dcjones]

Good day to you all.

I ahve a table with 2 fields:

member_id, INT, indexed with auto-increment
login, VARCHAR

I have one record in the table:

member_id = 1338000
login = 1338000

What I want to do is to insert another 1000 records incremmenting both the current field content so the result would be
member_id,login
1338000,1338000
1338001,1338001
1338002,1338002
1338003,1338003

and so on.

I am not sure which is the best way to do this, can anyone give me some advise please.

[laserlight]

What does this table model?

If you want to keep the current table as is, one way is to create the rows, then just set login=member_id for all of them.