SELECT * FROM table_name AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM table_name)) AS id) AS r2 WHERE r1.id = r2.id ORDER BY r1.id ASC LIMIT 5;
create table t (name varchar(32), no int);mysql delimiter //mysql create procedure test_insert (a int)- begin- set @i = 1;- while @i a do- insert into t values('abc', @i);- set @i = @i + 1;- end whil ...
# /etc/init.d/mysql stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking # mysql -u root mysql mysql UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; mysql FLUSH P ...
