溯洄蒹葭黎

查看数据库密码设置限制 SHOW VARIABLES LIKE 'validate_password%'; 修改为最低限制 set global validate_password.policy=LOW; 修改长度为6位 set global validate_password.length=6; 创建用户 create user 'root'@'%' identified with mysql_...

直接贴代码 SELECT * FROM table AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM table)-(SELECT MIN(id) FROM table))+(SELECT MIN(id) FROM table)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id L...