使用rand函數(shù)隨機模擬數(shù)據(jù)筆記
-- 生成隨機數(shù) 模擬數(shù)據(jù) ,隨機 1-2
SELECT floor(rand()*2)+1
-- 修隨機設置用戶的性別 1-2
UPDATE `user`
SET sex = (SELECT floor(rand()*2)+1)
-- 隨機排序
SELECT * FROM `user` u ORDER BY rand()
-- 隨機用戶頭像
UPDATE
`user`
SET
avatar = (
SELECT
ma.url
FROM
mock_avatar ma
ORDER BY
rand()
LIMIT 1
)
