• Post Reply Bookmark Topic Watch Topic
  • New Topic

MySQL adding property to a coloum

 
Pradeesh Pakkat
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,

I am new to MySQL.How can i add unique feature for my specified coloum? I am using MySQL.

Please help
 
E Armitage
Rancher
Posts: 989
9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you mean add unique constraint? Look in the mysql refmanual for the syntax of ALTER TABLE ADD CONSTRAINT clauses which you can use to add a unique constraint.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!