distal-attribute
distal-attribute
distal-attribute
distal-attribute

max recored in a table

User, date Message
Written by bhargavgrao
5 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
5 years ago
5015 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
5 years ago
104 posts since Sun, 01 Apr 07

wrote: 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)



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.