mysql
梦之翼618720
蚓无爪牙之利,筋骨之强,上食埃土,下饮黄泉,用心一也
展开
-
Mysql导入sql文件报错Unknown collation ‘utf8mb4_0900_ai_ci‘
Mysql导入sql文件报错Unknown collation ‘utf8mb4_0900_ai_ci‘原创 2023-03-09 08:48:49 · 638 阅读 · 0 评论 -
MySQL报错1055解决办法
最近在mysql 8.0.15版本中发现一个问题,在执行完sql语句后报错:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause;原创 2023-02-01 10:57:49 · 2840 阅读 · 0 评论 -
SQL语句,关于随机分组后在随机排序
方法一select * from tblorder by checksum(rand()*class), checksum(rand(),name)方法二select * from tblorder by checksum(rand()*class), newid()注:checksum(rand()*class) 这个要求class必须是数字,要是非数字值,就不行了原创 2021-03-08 11:38:20 · 388 阅读 · 0 评论