Re: Why Oracle don't have AUTO_INCREMENT as in MySQL

From: Fuzzy <fuzzy.greybeard_at_gmail.com>
Date: 15 Apr 2007 06:36:02 -0700
Message-ID: <1176644162.469438.288600@l77g2000hsb.googlegroups.com>

On Apr 15, 2:12 am, "howa" <howac..._at_gmail.com> wrote:
> On 4月15日, 下午12時04分, "Fuzzy" <fuzzy.greybe..._at_gmail.com> wrote:
>
> > On Apr 14, 7:27 am, "howa" <howac..._at_gmail.com> wrote:
>
> > > Seems AUTO_INCREMENT is very handy and natural, anyone agree?
>
> > Seems SEQUENCE is very handy and natural. Why don't others implement
> > SEQUENCE?
>
> > /Hans
>
> I can't agree SEQUENCE is more handy than AUTO_INCREMENT as you need
> to do the same thing by two statements.

Your opinion. Can't disagree with opinion. Leads to troll-talk.

>
> Also, in real world, use of AUTO_INCREMENT as primary key (e.g. id) is
> in fact, quite intuitive.

Actually, quite counter-intuitive. Your assumption is that there must be an increment. Primary key is NOT incremental, just unique. Increment is a specific busy-ness rule that may have nada to do with primary key.

Putting too much into the definition can make thing go stoopid.

/Hans Received on Sun Apr 15 2007 - 08:36:02 CDT