Re: [SQL] transposing data for a view

H Jeremy Bockholt schreef: > I have a generalized table: > > scanid | region | volume > - > 1 A 34.4 > 1 B 32.1 > 1 C 29.1 > 2 A 32.4 > 2 B 33.2 > 2 C 35.6 > . > . > . > > I want to creat

Re: [SQL] Auto Increment

On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu" <[EMAIL PROTECTED]> wrote: >hi all, > >could anyone tell me how to make a primary key to AUTO INCREMENT. The >document is not exactly very explainatory about it :) > >Thankx in advance ... > > > >Mayuresh > > Try first creating a sequence and t