Unique key problem

[sivanath.nagendran]

Hi I am newbie to SQL queries and aso database field. I need one help, how to assign to one variable as a Unique key?Pls anyone can help to this. Explain me more brieflyAdvance thanks for your concentration.BySivanath.N

[aspnetguy]

what database are you using?

[sivanath.nagendran]

I am using MySQL database.

[aspnetguy]

here are all the options when creating a column

olumn_definition:	col_name data_type [NOT NULL | NULL] [DEFAULT default_value]	  [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]	  [COMMENT 'string'] [reference_definition]

[justsomeguy]

You need to define the column as a primary key, and give it the auto_increment option. The datatype needs to be an integer. If you are using something like phpMyAdmin to set up the database then you can do it graphically, or else you need to write the SQL to do it.