Dependent Origination

unique constraints in mysql

Posted on: December 4, 2012

1. how to show the current constraints of a table?

mysql> show create table table_name;

It will also show updates, not just what is being executed at the time of create table.

2. drop a unique constraint

mysql> alter table table_name drop index constraint_name;

even if you didn’t give the constraint a name when you created it, you can still find the name from the above ‘show create table’ command.

3. add a new unique constraint

mysql> alter table table_name add constraint constraint_name unique (column 1, column 2, …);

Advertisements
Tags:

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

December 2012
M T W T F S S
« Nov   Jan »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Twitter

  • is reflecting on the past three years and reading the article on divided self aptly showing up at the top of my tweeter feed. 3 days ago
  • is having a nice feeling of connecting dots all over the place. they are now illuminating the same point. 1 month ago
  • Style Transfer is fun! TensorFlow rocks! #WTM17 https://t.co/zYP0IFIDfp 3 months ago
  • couldn't get over the jetlag, sleeping during the day from seven to four, for days. 5 months ago
  • is emptying trash and happily discovering the available disk space now ranks at 100G+. 6 months ago

Flickr Photos

IMG_3517

IMG_3515

IMG_3505

IMG_3497

IMG_3261

IMG_3260

IMG_3255

IMG_2736

IMG_2733

IMG_2629

More Photos
%d bloggers like this: