From: Andrey Alferov
Date: March 30 1999 1:30am
Subject: Re: Using unique, and using auto_increment
List-Archive: http://lists.mysql.com/mysql/1168
Message-Id: <001d01be7a4c$ed91a180$891f7dc1@nkaz.kemerovo.su.nkaz.kemerovo.su>

>Also, it would be nice to use the AUTO_INCREMENT feature for Number.  How
is
>this used?  What is the syntax, for an INSERT and for an UPDATE statement?

In INSERT you can leave this field empty. Field automatically filled in
MySQL
In UPDATE don't correct this field.

Andrey Alferov
Editor-in-chief Russian on-line magazine "Game Tower"
e-mail: aag@stripped
Game Tower: http://kulichki.rambler.ru/~tower/

>
>Thanks,
>John
>
>--
>
>John Taylor                 Large Scale Distributed Information Systems
>System Administrator        Computer Science Dept, University of Georgia
>john@stripped             http://lsdis.cs.uga.edu/
>                            (Where our programs are Y1.999K compliant :-)
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread1164@stripped
>
>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@stripped instead.