Re: Neuer Listen-Index

[Matthias Pigulla <mp_(at)_webfactory.de>]

Oliver Artelt wrote:
> Zeitlich und raeumlich eindeutige Schluessel werden haeufig benoetigt.

Anbei noch eine Mail, die gerade über die englische Liste ging. ;-)

Matthias
-- 
   w e b f a c t o r y | matthias pigulla
      www.webfactory.de  mp_(at)_webfactory.de

---- Begin included message ----

• Subject: Re: What is the Use of AUTO_INCREMENT?
• From: "Christian Mack" <Mack_(at)_compal.de>
• Date: Fri, 09 Apr 1999 22:19:43 +0200
• CC: mysql_(at)_lists.mysql.com
• Content-Transfer-Encoding: 8bit
• Delivered-To: wf-mp_(at)_webfactory.de
• Delivered-To: mailing list mysql_(at)_lists.mysql.com
• List-Help: <mailto:mysql-help_(at)_lists.mysql.com>
• List-Post: <mailto:mysql_(at)_lists.mysql.com>
• List-Subscribe: <mailto:mysql-subscribe_(at)_lists.mysql.com>
• List-Unsubscribe: <mailto:mysql-unsubscribe-mp=webfactory.de_(at)_lists.mysql.com>
• Mailing-List: contact mysql-help_(at)_lists.mysql.com; run by ezmlm (http://www.ezmlm.org)
• Organization: COMPAL GmbH
• References: <199904090634.PAA07520_(at)_tiger1.nownuri.net>

"ÇãÁ¤¼ö" 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


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread1614_(at)_lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe_(at)_lists.mysql.com instead.

---- End included message ----