Hi All;
Does mysql put some kind of restrictions on the count of records ?
as far as I read about ,the answer is "NO".. but I tried to insert some data to mysql database and when the records reach this number (1599) the table will not accept more whilst the script continue working , I tried to empty the table and do the insertion again ,but also at the same record it will not insert more, I changed the file name , the data, and ecexution time .. but nothing change .... can any one help me ??
MySql Restrictions
Moderator: General Moderators
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: MySql Restrictions
What is your database structure. More importantly what are your column types?
Re: MySql Restrictions
Is your server out of disk space? lol.... by default no, there are no restrictions. You should get an error from the mysql server though. I've successfully worked with 50,000,000+ rows no problem.