涛子 - 简单就是美

摘要： sqlalchemy.exc.OperationalError OperationalError: (_mysql_exceptions.OperationalError) (1055, "Expression 1 of SELECT list is not in GROUP BY clause a 阅读全文

摘要： https://docs.sqlalchemy.org/en/latest/orm/tutorial.html http://docs.sqlalchemy.org/en/latest/core/sqlelement.html 条件过滤操作 去重与降序 bulk insert & update & 阅读全文

摘要： ```bash #分组获得每个机柜里服务器占用的机架总数，如552807e6-b428-4184-b219-ae368c68ddb3占用4个 mysql> select cabinet_uuid, count(host_uuid) from rack where not host_uuid is NULL group by cabinet_uuid; +---------------------... 阅读全文