[Chicago] auto incrementing - what options do we have?
g at rrett.us.com
Fri Oct 10 16:42:33 CEST 2008
Just use an auto increment int column in mysql. The only reason you'd ever want to do that yourself is if you're a) bored, b) need something than other a simple incrementing integer c) will distribute the data across databases, in which case you'll need an approach that ensures key uniqueness.
----- "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.
> On Fri, Oct 10, 2008 at 8:53 AM, Lukasz Szybalski
> <szybalski at gmail.com> wrote:
> > Hello,
> > I was wondering if anybody has a good strategy for auto incrementing
> > I want to auto increment field called "case#" .
> > I have a choice of database auto increment on field "case#" or do
> > myself? (correct? No other choices exists? or something in
> > 1. I would like to be able to do pick a number where we will start
> > doing a case#? (1,000,000+)
> > 2. Reserver a case# for a special group which can auto increment
> > between 2,000,000-2,999,999, and add them as they come.
> > 3. I don't want to use (system_id)
> > So it seems as the only way is to make my primary key:
> > case# - unique key, primary, not auto incrementing and let some
> > program manage auto incrementing.
> > What options have worked for you in this situation?
> > So right now options are:
> > 1. let db auto increment
> > 2. Hold the next case# in a separate database table, and let my
> > program use it to find next case# value. How would I lock/unlock
> > next case# to make sure there is no race condition and each case#,
> > there is no holes?
> > 3. Any other options?
> > Have people used other strategy that is semi-automatic, and would
> > for these cases?
> > Thanks,
> > Lucas
> > --
> > Python and OpenOffice documents and templates
> > http://lucasmanual.com/mywiki/OpenOffice
> > Fast and Easy Backup solution with Bacula
> > http://lucasmanual.com/mywiki/Bacula
> > _______________________________________________
> > Chicago mailing list
> > Chicago at python.org
> > http://mail.python.org/mailman/listinfo/chicago
> JS Irick
> Lead Engineer
> Cacioppo Labs
> Center for Cognitive and Social Neuroscience
> Chicago mailing list
> Chicago at python.org
More information about the Chicago