wolverine my wrote: > Yes, I agree on what you have described. > > However, what should we do when the value is reaching the maximum? To > alter the data type to a bigger one?
Yes - convert the data type to a larger one. If you've got a mediumint, for example, you can convert it to an unsigned mediumint. The 'unsigned' bit means that the field won't store negative values - this gives you twice the positive numbers you can store. Otherwise if you're already using an unsigned data type, then just go up to the next data type ( eg mediumint to int, or int to bigint, etc ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
