From: Christian Mack
Date: April 9 1999 8:19pm
Subject: Re: What is the Use of AUTO_INCREMENT?
List-Archive: http://lists.mysql.com/mysql/1614
Message-Id: <370E60DF.10AC24A7@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

"ΗγΑ€Όφ" wrote:
> 
> Hi there
> 
> would U mind to tell me the use of AUTO_INCREAMENT?
> 
> Does ANSI  SQL support it?
> 
> Thanks a lot
> 
> Have a nice day!

Hi

AUTO_INCREMENT is not at all standard SQL.
This only works for mysql.
It is used to generate automatically a unique ID integer per table.

In SQL you use sequences for this task.
But with sequences you can do additional things (= don't mix these two up :)

Hope this clarified it a bit.

Tschau
Christian