Set a unique key for MySQL

Environment: NavicatforMysql8.2MySQLSever5.1 problem: MySQL graphic setting unique key solution: graphical tools do not have this function. You can use SQL commands. 1. modify a table, such as ALTERTABLEtablenameADDUNIQUE [index name] (column list). 2. Specify an index when creating a table, for example, CREATETABLEta.

Environment: NavicatforMysql8.2 MySQL Sever 5.1 problem: MySQL graphic setting unique key solution: graphical tools do not have this function. You can use SQL commands. 1. modify a TABLE, for example, alter table tablename add unique [index name] (column list); 2. Specify an index when creating a TABLE, for example, create table ta

Environment: NavicatforMysql8.2 + MySQL Sever 5.1

Problem: Set the unique key in the MySQL graphical interface

Solution: this function is not available in graphic tools. You can use SQL commands.

1. modify a table, for example

Alter table tablename add unique [index name] (column list );

2. Specify an index when creating a table, for example

Create table tablename ([...], UNIQUE [index name] (column list ));

References:

Http://hi.baidu.com/k45hifz/item/c977720eeeaaff183b53ee5e

Http://topic.csdn.net/u/20070604/15/f748623b-b871-43cc-b9f3-81fba8425774.html? Seed = 110138474 & r = 55821404 # r_55821404