Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

FAQ
It is currently Tue Oct 22, 2019 10:35 am


Mysql Application & Query Optimization, Questions, Indexes, Bugs.

Author Message
debuser
Post  Post subject: Mysql add Unique index to a table column  |  Posted: Fri Aug 06, 2010 10:01 am

Joined: Thu Aug 06, 2009 2:48 am
Posts: 105

Offline
 

Mysql add Unique index to a table column

The syntax for adding a unique index to a mysql table is the following
Code:
mysql> ALTER TABLE table_name ADD UNIQUE (clumn_name);





Top
Display posts from previous:  Sort by  
E-mail friendPrint view

Topics related to - "Mysql add Unique index to a table column"
 Topics   Author   Replies   Views   Last post 
There are no new unread posts for this topic. MySql drop unique key/index/constraint

admin

1

7828

Wed Mar 23, 2011 8:39 pm

dugEdiguift View the latest post

There are no new unread posts for this topic. Mysql: add column to table

debuser

1

2975

Fri Oct 08, 2010 1:38 am

sonee4 View the latest post

There are no new unread posts for this topic. Mysql remove column from an existing table

debuser

0

1530

Fri Aug 06, 2010 10:06 am

debuser View the latest post

There are no new unread posts for this topic. MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)

debuser

0

2303

Mon Feb 22, 2010 1:43 pm

debuser View the latest post

There are no new unread posts for this topic. Mysql - Change position of a column after another column

admin

1

3427

Fri Oct 08, 2010 1:41 am

sonee4 View the latest post

There are no new unread posts for this topic. Mysql drop (remove) unique key

mandrei99

0

1877

Wed Jan 14, 2015 7:53 pm

mandrei99 View the latest post

There are no new unread posts for this topic. Mysql change column's default value

debuser

0

1960

Thu Aug 12, 2010 3:43 am

debuser View the latest post

There are no new unread posts for this topic. Rename MySql table

debuser

1

1549

Fri Oct 08, 2010 1:36 am

sonee4 View the latest post

There are no new unread posts for this topic. MySql rename table

admin

2

1974

Mon Nov 28, 2011 3:39 am

Darwin View the latest post

There are no new unread posts for this topic. How to calculate mysql time difference between unix timestamp column and now() format

mandrei99

0

8499

Fri May 31, 2013 4:10 am

mandrei99 View the latest post

 

Who is online
Users browsing this forum: No registered users and 1 guest
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
Jump to:  
News News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list


Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]



phpBB SEO