spring boot jpa自动创建mysql表,发现报错:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=MyISAM' at line 1
低版本用的是:type=******,高版本需要用engine=******
正常拼的sql应该是: engine=MyISAM
spring boot文件修改方法:
spring.jpa.properties.hibernate.dialect: org.hibernate.dialect.MySQL5Dialect #engine=MyISAM
或者
spring.jpa.properties.hibernate.dialect: org.hibernate.dialect.MySQL55Dialect #engine=InnoDB 也能成功