Re: Limit to size of autoindex in MySQL/PHPMyAdmin?

On Friday, January 3, 2003, at 08:59 am, Leif K-Brooks wrote:

The limit to tinyint is 255... use int.

On Friday, January 3, 2003, at 09:02 am, Jasper Bryant-Greene wrote:

Change the field type from TINYINT to SMALLINT or MEDIUMINT. UNSIGNED TINYINT only has a range of 0 thru 255.

Thanks so much guys. I've made the change, tried again, and all is well. I opted for SMALLINT because its range is more than adequate for my needs. Whew! Relief! Sorry for not thinking of going first to the source. Having read your posts I went back to the MYSQL manual and checked out Column Types. In my defence all I can say is that I'll remember it better this way ;-) Jim MacCormaic Dublin, Ireland iChat/AIM : curlytool@mac.com