| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Tom Crimmins | Date: | February 22 2005 10:21pm |
| Subject: | RE: Is there a limit on Auto-increment | ||
| View as plain text | |||
On Tuesday, February 22, 2005 16:12, gunmuse@stripped 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
| Thread | ||
|---|---|---|
| • Is there a limit on Auto-increment | gunmuse | 22 Feb |
| • RE: Is there a limit on Auto-increment | Tom Crimmins | 22 Feb |