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