> Just a simple question (I think). > > When should I use tinyint over int. and what is the difference between the > two?
MySQL manual section 7.3 (data types): tinyint (8bit), range is 0 to 255 (unsigned) -128 to 127 (signed) int (32bit), range is 0 to 4294967295 (unsigned) -2147483648 to 2147483647 (signed) Basically, only use tinyint if you are desperate to save some space and you know a value will never, ever be outside its range; otherwise use int. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php