On Tuesday, February 22, 2005 16:12, [EMAIL PROTECTED] wrote: > I am using the memory table in 4.1 to auto increment is there a limit > to how big that number can get?
It is only limited by the size of your int. I would suggest declaring the column unsigned. This will give you twice the positive values for your column. An unsigned bigint gives you the ability to have 2^64 - 1 unique values. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]