MySql Restrictions

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bandany
Forum Newbie
Posts: 1
Joined: Wed Sep 17, 2008 11:28 am

MySql Restrictions

Post by bandany »

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 ??
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: MySql Restrictions

Post by jaoudestudios »

What is your database structure. More importantly what are your column types?
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: MySql Restrictions

Post by josh »

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.
Post Reply