MySQL-table

创建表

执行语句

CREATE TABLE `table_name` (  
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,  
  `colunm_1` VARCHAR(128) DEFAULT NULL,  
  `colunm_2` TINYINT(4) DEFAULT NULL,  
  PRIMARY KEY (`id`),  
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8  

查看表结构

执行语句

show create table table_name;

显示结果

CREATE TABLE `table_name` (  
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,  
  `colunm_1` VARCHAR(128) DEFAULT NULL,  
  `colunm_2` TINYINT(4) DEFAULT NULL,  
  PRIMARY KEY (`id`),  
  UNIQUE KEY `table_name` (`colunm_1`,`colunm_2`)  
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8  

添加联合唯一约束

添加约束字段

mysql>alter table table_name add unique key(colunm_1,colunm_2);

Query OK, 0 rows affected (0.55 sec)
Records: 0  Duplicates: 0  Warnings: 0

查看表结构

mysql>show create table table_name;

CREATE TABLE `table_name` (  
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,  
  `colunm_1` VARCHAR(128) DEFAULT NULL,  
  `colunm_2` TINYINT(4) DEFAULT NULL,  
  PRIMARY KEY (`id`),  
  UNIQUE KEY (`colunm_1`,`colunm_2`)  
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8