SELECT p.UserID INTO User_ID FROM p
INNER JOIN
(SELECT ROUND(RAND()*(SELECT MAX(UserID) FROM p)) AS UserID) AS r2
WHERE p.UserID>=r2.UserID and status = 0 ORDER BY p.UserID ASC LIMIT 1;
delete from p where userid = User_ID;
你懂的
SELECT p.UserID INTO User_ID FROM p
INNER JOIN
(SELECT ROUND(RAND()*(SELECT MAX(UserID) FROM p)) AS UserID) AS r2
WHERE p.UserID>=r2.UserID and status = 0 ORDER BY p.UserID ASC LIMIT 1;
delete from p where userid = User_ID;
你懂的