auto increment

[pokeronald]

hi, i want like when sumbody signs up and the id number increase automatically. in the db, which type do i use? when i tried some of the options, there was an error :

[shivabharat]

An example

 

Hope this helps

 

CREATE TABLE `emp` (`Id` bigint(20) NOT NULL auto_increment, `name` varchar(20) default NULL,`age` int(10) default NULL,`details` varchar(200) default NULL,PRIMARY KEY  (`Id`)  );

[pokeronald]

error message:

 

\"Incorrect table definition; There can only be one auto column and it must be defined as a key\"

 

what does that mean?

[gizmola]

error message:

 

\\\"Incorrect table definition; There can only be one auto column and it must be defined as a key\\\"

 

what does that mean?

 

It means that there can only be one auto_increment column per table, and that column must be a key for the table, usually the primary key.

[bAnthony]

are you using phpMyAdmin or just writing scripts?

[pokeronald]

but there IS no auto_increment else in my table...

 

i\'m using phpadmin

 

then how do u define it as a key?

[gizmola]

If the table already exists, you would need to use alter table.