At 1:29 -0600 11/25/04, tom miller wrote:
yes i do have tinyint and i have even tried mediumint both of which i
set the value to 255 knowing i will never come close to filling that
many rows
this is in a database shared with phpbb2 and i included a script to
log the ip browser and a timestamp.
the table is called ipbrowser and the columns are:
id tinyint(255) ip (20) browser(100) timestamp(14)
I'm unable to make sense of that, because it's not a legal
table definition and only id is associated with a data type.
However, the (255) following tinyint has nothing to do with
maximum value. Maximum value for an integer is a function
of the data type and whether or not it is unsigned, not
the display width. It looks to me like you need to use a
larger integer data type.
http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html
http://dev.mysql.com/doc/mysql/en/Numeric_types.html
On Wed, 24 Nov 2004 22:02:41 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 21:53 -0600 11/24/04, tom miller wrote:
>what is the maximum number of entries that table can hold?
>i have been experimenting with php and mysql.
>
>i created a script that records iipaddress, browser info and timestamp
>once the table reaches 127 entries it stops, is there a way to
>increase this number?
>
>i read thru the administrators guide but i didnt see the information i
>was looking for.
>
>thanks for any answers/or suggestions
> Do you have a TINYINT column that has the AUTO_INCREMENT attribute?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]