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());
You meaaan, auto incrementing field ???
If so
CREATE TABLE t_name (id INT AUTO_INCREMENT);
Workds.
But there's no auto digital number thingy
Sent on Jul 4 by Web Mailing List to [EMAIL PROTECTED]
websig I move from MDB to mySQL, I got a question concern how to create a auto
digital
I think you are looking for something like:
create table namelist (ID int not null auto_increment, name char(60), ...);
?!?
Cheers, Nessi
At 15:21 04/07/01 , you wrote:
I move from MDB to mySQL, I got a question concern how to create a auto
digital number field in mysql table,
create table
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