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