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

max recored in a table

bhargavgrao posted 5 years ago in General
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...
ansgar posted 5 years ago
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
siMKin posted 5 years ago

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.