随笔分类 -  mysql

1 2 3 下一页
group by 和 max
摘要：聊聊MySql8.0中的group by 和 max函数取最新(优)一条记录的问题 https://zhuanlan.zhihu.com/p/414683659 MySQL之group by与max()一起使用的坑 https://blog.csdn.net/qq_44690947/article/ 阅读全文
posted @ 2022-12-13 16:58 tonggc1668 阅读(47) 评论(0) 推荐(0)
mysql slow log
摘要：/etc/my.cnf[mysqld]slow_query_log = ONslow_query_log_file = /usr/local/mysql/data/slow.loglong_query_time = 2SHOW VARIABLES LIKE '%query%'; Variable_n 阅读全文
posted @ 2022-11-25 17:30 tonggc1668 阅读(27) 评论(0) 推荐(0)
mysql 主从 参数
摘要：mysql主从模式原理与配置 https://www.cnblogs.com/chq3272991/p/15573612.html Mysql - 关于relay_log_recovery参数的测试 https://www.cnblogs.com/ddzj01/p/11592148.html rel 阅读全文
posted @ 2022-09-22 16:58 tonggc1668 阅读(29) 评论(0) 推荐(0)
Last_Error: Relay log read failure: Could not parse relay log event entry.
摘要：Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by r 阅读全文
posted @ 2022-09-22 15:45 tonggc1668 阅读(124) 评论(0) 推荐(0)
[ERR] 1231 - Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
摘要：https://blog.csdn.net/ShameWoo/article/details/100533452 在将mysql5.7导出的.sql文件运行在MySQL8上报标题错误。 原因：MySQL8取消了NO_AUTO_CREATE_USER 解决方案：把.sql文件里的 'NO_AUTO_C 阅读全文
posted @ 2022-07-08 17:57 tonggc1668 阅读(1334) 评论(0) 推荐(0)
MySQL ALTER USER修改密码
摘要：MySQL使用ALTER USER修改密码 https://blog.csdn.net/omaidb/article/details/120036628 Mysql5.6 ERROR 1396 (HY000): Operation CREATE USER failed for 'xxxx'@'loc 阅读全文
posted @ 2022-04-29 23:34 tonggc1668 阅读(821) 评论(0) 推荐(0)
springboot2.x集成 liquibase
摘要：若依（springboot2.x）集成 liquibase https://www.wyl.im/archives/77 liquibase集成springboot使用步骤（全网最详细） https://wukainian.blog.csdn.net/article/details/10635556 阅读全文
posted @ 2022-03-03 09:58 tonggc1668 阅读(174) 评论(0) 推荐(0)
mysql 报错This function has none of DETERMINISTIC解决方案
摘要：https://www.jb51.net/article/97037.htm 开启bin-log日志mysql报错:This function has none of DETERMINISTIC, NO SQL解决办法, 创建存储过程时 出错信息： ERROR 1418 (HY000): This 阅读全文
posted @ 2022-03-02 17:29 tonggc1668 阅读(166) 评论(0) 推荐(0)
mysql jdbc timezone
摘要：MySql的时区（serverTimezone）引发的血案 https://www.cnblogs.com/zhuitian/p/12436300.html java 解决date 类型的时间插入mysql中差8小时 https://www.shangmayuan.com/a/d0aa20937e0 阅读全文
posted @ 2022-02-14 09:50 tonggc1668 阅读(133) 评论(0) 推荐(0)
mysql HA
摘要：MySQL5.7+Keepalived双主HA架构 https://blog.csdn.net/cuiruidu3106/article/details/100438947 HA部署步骤 1、mysql_check.sh脚本 发现mysql挂了 杀死本机的keepalived 主备均部署 cat > 阅读全文
posted @ 2022-02-10 19:49 tonggc1668 阅读(284) 评论(0) 推荐(0)
binlog_ignore_db引起的同步复制故障
摘要：binlog_ignore_db引起的同步复制故障 https://blog.csdn.net/cuiruidu3106/article/details/100439021 replicate_wild_do_table和replicate-wild-ignore-table的使用【转】 https 阅读全文
posted @ 2022-02-10 13:32 tonggc1668 阅读(40) 评论(0) 推荐(0)
MySQL @和@@ global变量和session变量
摘要：MySQL设置global变量和session变量的两种方法详解 https://www.jb51.net/article/148424.htm MySQL @和@@ https://blog.csdn.net/weixin_39004901/article/details/102622886 My 阅读全文
posted @ 2022-01-25 11:58 tonggc1668 阅读(161) 评论(0) 推荐(0)
sql_mode=only_full_group_by
摘要：MySQL关于only_full_group_by错误的解决方案 https://jingyan.baidu.com/article/5552ef471a15d2108ffbc9ef.html select @@sql_mode;set @@sql_mode='STRICT_TRANS_TABLES 阅读全文
posted @ 2021-12-17 12:27 tonggc1668 阅读(92) 评论(0) 推荐(0)
mysql 简单表和索引
摘要：CREATE TABLE `recover_plan` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID', `type` varchar(100) NOT NULL COMMENT '类型，主机异常，数据库异常，应用异常', `excepti 阅读全文
posted @ 2021-11-28 08:02 tonggc1668 阅读(42) 评论(0) 推荐(0)
DruidDataSource
摘要：import com.alibaba.druid.pool.DruidDataSource; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory 阅读全文
posted @ 2021-09-05 23:58 tonggc1668 阅读(321) 评论(0) 推荐(0)
mysql datasource-pool hikari
摘要：application.properties <spring.version>5.2.5.RELEASE</spring.version> <spring-boot.version>2.2.6.RELEASE</spring-boot.version> <mybatis-spring-boot-st 阅读全文
posted @ 2021-09-05 22:07 tonggc1668 阅读(145) 评论(0) 推荐(0)
cdc
摘要：四种CDC方案比较 https://cloud.tencent.com/developer/article/1433103 阅读全文
posted @ 2021-06-10 10:36 tonggc1668 阅读(56) 评论(0) 推荐(0)
mysql按分隔符输出多行
摘要：SELECT DISTINCT substring_index(substring_index(a.value, '\n', b.help_topic_id + 1), '\n',- 1) NAMEFROM t_cr_permission a JOIN mysql.help_topic b ON b 阅读全文
posted @ 2021-05-24 05:43 tonggc1668 阅读(210) 评论(0) 推荐(0)
mysql DATETIME
摘要：set @report_date = '2013-01-17 00:00:00';select @report_date; set @report_date = cast('2013-01-17 00:00:00' as datetime); SELECT @report_date; DECLARE 阅读全文
posted @ 2021-05-24 03:22 tonggc1668 阅读(92) 评论(0) 推荐(0)
解决MySQL安装:找不到msvcr120.dll和msvcp120.dll
摘要：MySQL免安装版,遇到MSVCR120.dll文件丢失错误的解决方法 找不到msvcr120.dll和msvcp120.dll 这是因为没有安装微软常用运行库合集导致的 下载 VC redist packages for x64、x86 下载地址 https://download.csdn.net 阅读全文
posted @ 2021-05-23 12:00 tonggc1668 阅读(548) 评论(0) 推荐(0)

1 2 3 下一页