mysql 常见操作

创建唯一索引

alter table xxxx add unique(`a`, `b`);

查询mysql中非事务表

SELECT table_schema database_name,table_name,engine FROM information_schema.tables WHERE table_schema NOT IN ('mysql','information_schema','performance_schema','sys') AND engine <> 'InnoDB';

修改标的引擎

alter table xxx engine=innodb;