yep. That's the point of a tinyint, it only holds numbers 0-127. if you
need more then try smallint, int or bigint. (and please read the manual
regarding data types. It's clearly explained there.)
Cal
http://www.calevans.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dacian Herbei
Sent: Tuesday, March 27, 2001 11:50 AM
To: [EMAIL PROTECTED]
Subject: tinyint issue
Hi,
I wonder if anyone had a problem like this one.
I have created a table with one field autoincrement. The field is
tinyint(4).
whenever I try to introduce more then 127 records it refuses to
introduce them.
I tried with tinyint(5) 6.. and so on. It works only with integer.
dacian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
