mysql多表更新 從mysql數(shù)據(jù)表中隨機取出一條記錄?
從mysql數(shù)據(jù)表中隨機取出一條記錄?Order by rand()是一種隨機排序。Order by rand()limit 1是隨機獲取一行數(shù)據(jù)。滿足兩個條件:首先,從“user”中選擇*其中“se
從mysql數(shù)據(jù)表中隨機取出一條記錄?
Order by rand()是一種隨機排序。Order by rand()limit 1是隨機獲取一行數(shù)據(jù)。滿足兩個條件:首先,從“user”中選擇*其中“sex”=“male”和“Ctiy”=“Guangzhou”order by rand()limit 1