max number of rows?

[seanlyons]

I have a users table, and I tried a mass import. Very few fields. an id field (which is a unique, primary key and auto increment) and a username and password field.

I used an insert command, left the no data in the insert corresponding to the id field, the insert got to row 127, and then failed with error 1062, saying that primary was not unique. Now if I try to insert even row at a time, it gives me the same message. If i remove the unique and primary restriction from the field the problem is gone. But I would like this column to be the primary key! Anyone know anything that could shed some light?

[Sxooter]

You have made the mistake of using a tinyint.

Your table was made something like this:

create table table1 (id tinyint autoincrementing)

so it stops at 127.

You need to recreate your table with just plain int.