springdataJPA mysql myisam innodb

spring-data (踩坑记录) --- 默认mysql引擎为myisam

https://blog.csdn.net/woxinqidai/article/details/82751240?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.channel_param

 

修改表和库

https://www.cnblogs.com/afish/p/3969756.html

 

select CONCAT('alter table ',table_name,' engine=InnoDB;') FROM information_schema.tables WHERE table_schema="数据库名" AND ENGINE="MyISAM";


ALTER TABLE `apigateway-ai`.`ai_person` ENGINE = InnoDB;