Ok, this is really confusing me...
I have a table containing ID, Cat, SubCat and Type. ID is auto_increment and the rest just text. When I came to insert the 128'th record (leaving ID blank cos it's done automatically), it said that 127 already existed! I tried manually putting 128 in, and it still said 127 existed!
Any ideas?
I can't see there being a limit in a table, I'm stumped!
Danny
I have a table containing ID, Cat, SubCat and Type. ID is auto_increment and the rest just text. When I came to insert the 128'th record (leaving ID blank cos it's done automatically), it said that 127 already existed! I tried manually putting 128 in, and it still said 127 existed!
Any ideas?
I can't see there being a limit in a table, I'm stumped!
Danny