![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
桃园狂刀
keep calm and carry on!
展开
-
SQL递归--MySQL
WITH RECURSIVE tmp0 AS ( SELECT a.* FROM table1 a WHERE a.id = #{id} UNION SELECT t1.* FROM table1 t1, tmp0 t0 WHERE 1 = 1 AND t1.parent_id = t0.id ) SELECT a.field1, ...原创 2019-10-24 09:17:18 · 164 阅读 · 0 评论 -
“Host is blocked because of many connection errors”问题解决
环境Linux、MySQL 5.5报错Host ‘hostname’ is blocked because of many connection errors; unblock with 'mysqladmi.原因该host上部署的服务因数据库帐号配置错误,导致短时间内连接MySQL服务失败次数超过max_connection_errors参数设定值(默认10),从而被拒绝。解决方法方法一:刷新记录原创 2017-08-24 15:16:00 · 2310 阅读 · 0 评论 -
mysql异常1548-Cannot load from mysql.proc. The table is probably corrupted
异常描述1548-Cannot load from mysql.proc. The table is probably corrupted数据库再执行数据导出时报出了这个异常,显示是“无法执行mysql存储过程,这个表已经损坏”。 网上查找了资料原因是:mysql.proc升级时有个字段没有升级成功。在5.1中mysql.proc表的comment字段是varchar(64):原创 2018-01-30 10:47:05 · 5127 阅读 · 1 评论 -
java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Tim 异常解决办法
出现这个异常是由于数据库中关于 datetime 字段记录中出现了值为 0000-00-00 00:00:00 的一条记录,解决方法:删掉此条记录,或者更改为有效数据Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestampat com....原创 2018-06-08 09:31:55 · 861 阅读 · 0 评论