mysql - 文章分类 - 钱有学

SQL语句：保留小数点后两位

摘要：待修改的sql语句片段 ```sql AVG(relative) as avgHumidity, ``` 在 AVG 函数的结果上使用 ROUND 函数 ```sql ROUND(AVG(relative), 2) as avgHumidity ``` 阅读全文

posted @ 2023-07-17 17:02 钱有学阅读(124) 评论(0) 推荐(0)

彻底卸载Mysql

摘要：https://blog.csdn.net/Mei_yu_01/article/details/121922577 阅读全文

posted @ 2023-04-12 12:01 钱有学阅读(8) 评论(0) 推荐(0)

版本问题：mysql报错＞ 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

摘要：https://blog.csdn.net/weixin_44013783/article/details/119422353?ydreferer=aHR0cHM6Ly93d3cuYmFpZHUuY29tL2xpbms%2FdXJsPTJMcmVKLWlHVjZONWRObW5PX0FSbFlIbk 阅读全文

posted @ 2023-04-12 12:00 钱有学阅读(88) 评论(0) 推荐(0)

文章分类 - mysql

公告