mysql 常用

1. 添加和去除 unique 约束
   alter table YourTABLE add unique(YOURCOL);
alter table YourTABLE drop index YOURCOL;
2. 添加联合约束

alter table YourTABLE
add unique key(YOURCOL1, YOURCOL2);

1. 添加注释
   alter table YourTABLE modify column YOURCOL varchar(100) comment 'XXX';

   show full columns from YourTABLE;