Autonumber in SQL

[mattster]

Hi, I want to make a certain column do something like autonumber (from MS Access)... I know i have to set the column to be the primary key, and set it to AUTO_INCREMENT, but I don't know how to do that.. can anyone help me out? Thanks in advance!

 

[codestorm]

What type of database? codestorm

 

[mattster]

I'm using MySQL... whatever the default is :T

 

[codestorm]

Doh, haven't used MySQL enough to be much help there.
I know in Access to do it using SQL would be something like

create table abc (field1 COUNTER, etc etc) codestorm

 

[dianal]

Hello,
See the example:

CREATE TABLE client (
client_id int(8) DEFAULT '0' NOT NULL auto_increment,
city varchar(60),
state varchar(80),
country char(2),
postal_code varchar(13),
username varchar(32),
contact_email varchar(127),
PRIMARY KEY (client_id)
);

The format is given in the MySQL Manual

http://www.mysql.com/doc/C/R/CREATE_TABLE.html

Hope this helps.
D.