max recored in a table
| User, date | Message |
|---|---|
|
Written by bhargavgrao
4 years ago Category: General 1 posts since Sun, 13 Dec 09 |
hi every one ... can even one pls tell how many records can i store in a table myisam and what error i will get if limit is exceeded??? pls help thanks... |
|
Written by ansgar
4 years ago 4029 posts since Fri, 07 Apr 06 |
Error will be SQL Error 1114: The table 'xyz' is full There are different causes for that error, either * your auto_increment column has reached its maximum value (e.g. 256 for TINYINT UNSIGNED) * or the tablespace on the server is full. Latter one can be solved by increasing the average row length (see "Options" tab in HeidiSQL's table editor). See also http://jeremy.zawodny.com/blog/archives/000796.html |
|
Written by siMKin
4 years ago 104 posts since Sun, 01 Apr 07 |
wrote: Error will be SQL Error 1114: The table 'xyz' is full Actually, if the auto_increment reaches its maximum value you are most likely to get a duplicate-value error. (this happens when the auto_increment column also has a Primary Key / Unique index) |
|
Please login to leave a reply, or register at first. |