2023-04-22发表2023-04-23更新数据库

MySQL-8.0.24主从环境搭建

docker搭建创建MySQL容器

master主库

1	docker run -d -p 3316:3306 -e MYSQL_ROOT_PASSWORD=password -e TZ=Asia/Shanghai --name mysql-8.0.24-master mysql:8.0.24 --lower-case-table-names=1 --default-authentication-plugin=mysql_native_password

2021-04-12发表2023-03-18更新数据库

MySQL-5.7.28分组时报错1055

问题

问题描述

1
2

错误代码： 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ht-3.0.project_info.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

MySQL-8.0.24主从环境搭建

docker搭建创建MySQL容器

MySQL-5.7.28分组时报错1055

问题

最新文章

归档

分类

链接

标签