[Chicago] auto incrementing - what options do we have?
szybalski at gmail.com
Fri Oct 10 17:18:10 CEST 2008
On Fri, Oct 10, 2008 at 8:58 AM, John-Stockton Irick <irick at uchicago.edu> wrote:
> I'm going to assume that you're talking about mysql.
> >From mysql.org
> To start with an AUTO_INCREMENT value other than 1, you can set that
> value with CREATE TABLE or ALTER TABLE, like this:
> mysql> ALTER TABLE tbl AUTO_INCREMENT = 100;
> Hope that helps.
Problem with that is that I want to have more control on case#. So if
this case is from A source the auto increment starts at case# 3000 and
if its from source B auto increment starts with case# 4000.
More information about the Chicago