How to create a IDENTITY column in MySQL?

[kcravimss]

Please help me to create an IDENTITY column in MySQL

[pradeep kaltari]

Please help me to create an IDENTITY column in MySQL

Hi,
You can create identity column as:
1: While creating a table-->

CREATE TABLE table_name
(
   id INTEGER AUTO_INCREMENT PRIMARY KEY
)
 

The identity column needs to be specified as a key (PRIMARY or UNIQUE)

2: If the table already exists-->

ALTER TABLE table_name ADD COLUMN id INTEGER AUTO_INCREMENT UNIQUE KEY;
 

I hope this helps.

Regards,
Pradeep.

[pbmods]

CREATE TABLE table_name
(
   id INTEGER AUTO_INCREMENT PRIMARY KEY
)
 

The identity column needs to be specified as a key (PRIMARY or UNIQUE)

You can also do this:

CREATE TABLE table_name
(
    id serial
)
 

Which is equivalent to:

CREATE TABLE table_name
(
    id BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment
)
 

[parthi19]

create table table_name(id int(5), name varchar(30), primary key(id))