List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:July 15 1999 9:09pm
Subject:Re: autonumber?
View as plain text  
"div22@stripped" wrote:
> I am a beginner with SQL and here is something I came upon. How would I
> make a column to be filled with a numbers in sequence 1,2,3...n
> depending on the number of rows in a table. Something like Autonumber in
> Access. I am sure there is such thing, but I could not find it in the
> manual.
> Thanks.
> Denis
> denis@stripped

Hi Denis

You search the AUTO_INCREMENT feature.
In each table you can have one integer column with AUTO_INCREMENT set.
How to do this see the CREATE syntax somewhere in chapter 7 of the manual.


autonumber?div22@drexel.edu15 Jul
  • Re: autonumber?Sasha Pachev16 Jul
  • Re: autonumber?Christian Mack16 Jul