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.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to