>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.