MYSQL Table Limitations??

[lefkogt]

I have a hosting account on Hostway.com.

It appears I cannot add more than 127 records to a MYSQL table. Assume SQL syntax is correct. Is this a hosting company limitation, MYSQL limitation (doubt it), somthing else (setting somewhere)?

Any advice appreciated.
Gary

[Sxooter]

No, you just defined your table with an autoincrementing field as a tiny int. tiny ints are signed 8 bit numbers, so -128 to 127 is the range. I.e. it started at 1 and got to 127 and ran out of room.

[ultraslacker]

Appears? What happens when you try to add that 128th row?