Auto increment (Newbie)

2002-05-29 Thread r
Hey there, I know this might sound like a stupid question to a lot of you guys out there but please keep in mind I come from an oracle background and am new to this: I am accessing MySql from PHP, I have two questions regarding Auto_Increment 1) how to create an auto_increment? create table

Re: Auto increment (Newbie)

2002-05-29 Thread Ray a PowerWeb Tech
manual_Reference.html#CREATE_TABLE create_definition: col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [PRIMARY KEY] [reference_definition] create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20)); can't seem to find the ref right now, but