List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:April 9 1999 8:19pm
Subject:Re: What is the Use of AUTO_INCREMENT?
View as plain text  
"ÇãÁ¤¼ö" 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

Thread
What is the Use of AUTO_INCREMENT?wertyu9 Apr
  • Re: What is the Use of AUTO_INCREMENT?Christian Mack10 Apr