CREATE TABLE namelist (
       name           CHAR(60),
       id             SMALLINT AUTO_INCREMENT)

You will find much useful information at http://www.mysql.com - check 
the documentation section.  I also use the O'Reilly book "MySQL and 
mSQL" by Yarger, Reese and King, which has detailed information about 
MySQL and how to interact with it in Perl, PHP and other languages.


>I move from MDB to mySQL, I got a question concern how to create a 
>auto digital number field in mysql table,
>
>create table namelist ( name char(60), ID auto, date date());


-- 


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to