mysql隨機獲取十條 MySQL產(chǎn)生隨機數(shù)?
MySQL產(chǎn)生隨機數(shù)?Select round(round(rand(),4)*10000)不需要函數(shù)直接執(zhí)行此操作。如果必須編寫函數(shù),請將delete$$create function getura
MySQL產(chǎn)生隨機數(shù)?
Select round(round(rand(),4)*10000)不需要函數(shù)直接執(zhí)行此操作。如果必須編寫函數(shù),請將delete$$create function geturand()RETURNS INT DETERMINISTIC BEGIN DECLARE returnuno INT SELECT ROUND(ROUND(rand(),4)*10000)轉(zhuǎn)換為returnuno returnuuno END$$DELIMITER