appearappear的博客

SELECT t.id, any_value ( pp.xx_opin ) xxx_opin FROM sys_xxx t LEFT JOIN xxx pp ON t.id = pp.xxx_id GROUP BY t.id ORDER BY t.modified_date DESCany_value()会选择被分到同一组的数据里第一条数据的指定列值作为返回数据

如果使用Linux提示表不存在，设置大小写敏感配置在/etc/my.cnf添加lower_case_table_names=1，重启MYSQL服务

'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespacesGRANT ALL PRIVILEGES ON `xx-xx`.* TO 'xx'@'%' -- 使用“`”代替单引号GRANT PROCESS ON *.* TO 'spinuser'@'%'

临时设置：set global connection_control_max_connection_delay = 60000配置文件：/etc/mysql/conf.d/mysqlutf8.cnf[mysqld]# 连接控制插件,重启后生效;plugin-load-add = connection_control.so # 不加这个，mysql重启不起来connection_control_min_connection_delay = 3000connection_control.

mysqldump -h 'xxxx' -uroot -p'xxxx' -R -B -A --single-transaction |gzip > /mysql/mes_$(date +%Y%m%d_%H%M%S).sql.gz/usr/bin/find /mysql_bak/ -mtime +7 -exec rm -rf {} \;-RroutinescontainsCREATE PROCEDUREandCREATE FUNCTIONstatements-A --all-d...