List:General Discussion« Previous MessageNext Message »
From:Andrey Alferov Date:March 30 1999 1:30am
Subject:Re: Using unique, and using auto_increment
View as plain text  
>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.


Thread
Using unique, and using auto_incrementJohn Taylor30 Mar
  • Re: Using unique, and using auto_incrementFred Read30 Mar
Re: Using unique, and using auto_incrementAndrey Alferov30 Mar