phpmyadmin/mysql cant insert more then 99 records

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

phpmyadmin/mysql cant insert more then 99 records

Postby TurkmenCopur » 07. July 2010 16:54

Hello,

At the moment i have got 99 records in my table. When i try to insert one more record, the phpmyadmin client freezes, the record is not being inserted, and also no errorcode is given. If i delete my 99th record, and then try to insert a record, then there is no problem. Obviously there is a maximum limit, but i dont know how to set this limit higher.

I have 1 primary key field/column in the table with auto_increment and datatype=int(50).And there are also 13 more columns in the table, all with datatype varchar(200). What could be the reason for this problem?
TurkmenCopur
 
Posts: 1
Joined: 07. July 2010 16:52

Re: phpmyadmin/mysql cant insert more then 99 records

Postby Altrea » 07. July 2010 17:26

int(50) is nonsense.
Max value for unsigned Int is 4294967295 (10 Digits)
signed int can have a size of 11 (-2147483648)

But the number in the Brackets just define how many digits will be shown, not how many will be saved.

I know, that has nothing to do with your problem, but it's good to know :D
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6630
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest