Found non-empty schema(s) `demo` but no schema history table.

[已解决]数据库版本管理工具启动报错:org.flywaydb.core.api.FlywayException: Found non-empty schema(s) `demo` but no schema history table. Use baseline() or set baselineOnMigrate to true to initialize the schema history table.

Flyway failed to initialize: none of the following migration scripts

[已解决]数据库版本变更管理工具Flyway启动出现异常:Flyway failed to initialize: none of the following migration scripts。

Deadlock found when trying to get lock

[已解决]MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction.

Error Code: 1052. Column 'id' in field list is ambiguous

[已解决]MySQL执行报错:Error Code: 1052. Column 'id' in field list is ambiguous。

Failed to determine a suitable driver class

[已解决]Spring Boot项目启动报错:Failed to determine a suitable driver class。

mybatis generator同表不同库生成代码问题

[已解决]mysql数据库不同schema下有同名称表,mybatis generator插件生成代码会找错schema。

Mybatis SaveOrUpdate插件

Mybatis代码生成插件SaveOrUpdate写法,对应MySQL INSERT INTO ON DUPLICATE KEY UPDATE语法。

Error Code: 1136 - MySQL提示

Error Code: 1136. Column count doesn't match value count at row 1。

MySQL Error code '1205'

Unable to translate SQLException with Error code '1205', will now try the fallback translator。

清理MySQL死锁事务线程

MySQL死锁事务的处理方法:通过日志信息分析死锁事务的线程id,使用kill命令清理死锁事务。