what is unique key in mysql

  1. unique  is key and its always unique,    that means not repeat  ,
  2. unique is just like primary key but unique  may be NULL and primary key is not NULL

how to create unique key in mysql table

CREATE TABLE  tablename
(
id  int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
UNIQUE (id)
)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s