![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
Southwest-
专注大数据领域(Spark、Flink、Hadoop生态、Kafka、数据仓库、数据中台...)
展开
-
MySQL——MySQL分组排序取TopN、取第N条
mysql原创 2020-09-26 14:20:20 · 1086 阅读 · 0 评论 -
MySQL——MySQL SELECT查询非分组聚合列(sql_mode=only_full_group_by)
https://stackoverflow.com/questions/23921117/disable-only-full-group-byhttps://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html– set global sql_mode=(select replace(@@sql_mode, ‘ONLY_FULL_GROUP_BY’, ‘’));– select @@global.sql_mode;原创 2020-09-15 22:07:28 · 2083 阅读 · 0 评论 -
MySQL——MySQ行记录大小超过限制(Row size too large (> 8126). Changing some columns to TEXT or BLOB or ......)
背景Spark写MySQL,有太多列的长度都比较长MySQL中的可变长度类型variable-length typeA data type of variable length. VARCHAR, VARBINARY, and BLOB and TEXT types are variable-length types.InnoDB treats fixed-length fields greater than or equal to 768 bytes in length as variable-原创 2020-08-17 10:25:14 · 5195 阅读 · 0 评论