max recored in a table

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

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

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)