Hi,
How do I create a column which has an auto-generated number i.e. unique serialized number that increments by 1 on every insertion of a row?
Thanx.
Pooja

An example:

create table Student(id int auto_increment primary key, name varchar(30)) type=innodb;

mysql> insert into Student values(NULL, "Prasanna");

Inserting a NULL value will increment the value of id everytime.

Prasanna

hey thanx a lot for that...looks really cool....goin' to try it now!
pooja