Because
TINYINT has a MAX VALUES of 127
pre the mysql docs:
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.
if you unsign the column, you can get to 255
I would use something larger, because you will have more than 255 me
Joris Kluivers wrote:
>
> hi,
>
> i have a problem
> i have a database table created with the statement:
> CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT,
>message text, username varchar(100), UNIQUE id (id);
>
> I insert records with:
> INSERT INTO chatmessages
check the archive, someone answered that one this weekend.
Cal
http://www.calevans.com
-Original Message-
From: Joris Kluivers [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 04, 2001 5:56 AM
To: [EMAIL PROTECTED]
Subject: insert + AUTO_INCREMENT
hi,
i have a problem
i have a database
