MySql 唯一约束

 

 

#创建表books4给name添加列级约束

create table books4(

        id int(8),

        name varchar(30) unique,

        price float(3),

        date int(4)

)

#创建表books5给id添加表级约束

create table books5(

        id int(8),

        name varchar(30),

        price float(3),

        date int(4),

        constraint un_books5 unique (id)

)

# 给已有表books6添加唯一约束date

create table books6(

        id int(8),

        name varchar(30),

        price float(3),

        date int(4)

)

alter table books6 add constraint un_books6 unique(date)

# 删除表books6中的唯一约束

alter table books6 drop index un_books6