MUST READ: ALL MySQL Newbies!
| From: | Shane | Date: | Thu, 19 Sep 2002 23:49:35 +0000 |
| Subject: | MUST READ: ALL MySQL Newbies! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-116953@lists.php.net to get a copy of this message | ||
If you are a MySQL newbie you need to read this!
I just screwed up big time and lost about 1 hour of data in a time sensitive application by using
TINYINT as my ID field.
TINYINT will only allow up to 255 records in a MySQL DB. Please, if you don't know the EXACT
differences between all the different INTEGER types, please stop what you are doing and go to
mysql.com and read up. You may be surprised that the number you enter after your "INT(10)"
has nothing to do with what you think it means.
Ever wish someone could let you know ahead of time that you are about to screw up? Well this could
be it. Please learn from my mistake, fully understand INTEGER types if you ever plan on having a DB
grow above 200+ records.
Thanks crew.
- name withheld... too embarrassed right now.