sql语句
文章平均质量分 87
Ableson---仲夏蝉鸣
写博客
展开
-
MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
起因:中午测试测出公司系统保存有BUG,我在调试时无意发现程序卡着不动,20秒左右才调到debug断点。报错:### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting t...原创 2019-12-17 19:01:26 · 320 阅读 · 0 评论 -
[Err] 1267 - Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICI
用navicat(其它工具一样)查询sql语句,报错:分析:异常是排序规则编码混乱;我mysql是8.0.12版本,本次sql操作是连表查询,应该是两个表的编码格式不同所致,mysql8.0.1之后的默认COLLATE为utf8mb4_0900_ai_ci;查看当前数据库默认编码:show variables where Variable_name like ‘collation%’;!...原创 2019-08-19 13:58:18 · 21990 阅读 · 2 评论