随笔分类 -  MySQL

mysql多表联合查询 [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause this is incompatible with sql_mode=only_full_group_by
摘要：在 mysql进行 多表联合查询, 出现以下错误:[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clausewhich is not functionally dependent on columns in GROUP BY 阅读全文
posted @ 2021-06-02 11:51 Aliwall 阅读(133) 评论(0) 推荐(0)
RedHat 7.6 安装 Mysql 8.0.17
摘要：# 查看是否安装mysql rpm -qa | grep -i mysql # 如果有,需要卸载旧版本Mysql及相关依赖包 rpm -e MySQL-client-*** # 查看开机启动服务列表状态 systemctl list-unit-files # 禁用mysql服务 systemctl 阅读全文
posted @ 2019-08-22 20:06 Aliwall 阅读(6605) 评论(2) 推荐(0)
Mysql 添加 create_time, update_time 创建时间 更新时间 自动更新
摘要：# 添加 创建 更新 时间字段 ALTER TABLE `表名` ADD COLUMN `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `最后一个列名`, ADD COLUMN `update_time` timesta 阅读全文
posted @ 2019-08-17 11:33 Aliwall 阅读(11630) 评论(0) 推荐(2)