测试小鸡的博客

1: 安装docker2: docker下载mysql镜像(这里装的是mysql 8.0.24)3: docker下载canal镜像安装结果如下:安装步骤非常简单:docker pull mysql:8.0.24docker pull canal/canal-server4: 启动mysql容器 启动docker run -d --name mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306 mysql:...

遇到2次这个问题了:因为MySQL 5.6以后timestamp设定默认值规则改变，不能为”0000 00-00 00:00:00”;show session variables like '%sql_mode%';然后修改sql_mode,去掉NO_ZERO_IN_DATE,NO_ZERO_DATE:set sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_US

反射封装mapRow：参考：https://blog.csdn.net/ldz0414/article/details/84468749模板设计部分：//1、获取连接Connection conn = this.getConnection();//2、创建语句集PreparedStatement pstmt = this.createPreparedStatement(c...

update gz_user gz set gz.address =replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(re...