是否可以在mysql中只返回特定数量的数据集?
$connect = mysqli_connect("server", "root", "passwd", "database");
$query = mysqli_query($connect, "SELECT * FROM xy WHERE num = '315' DESC");
while($row = mysqli_fetch_assoc($query)){
/*return here only 5 datasets*/
}
抱歉,我是PHP新手
这很简单:
在你的SQL-Query中,你可以选择你想要的数据集的数量:
LIMIT 0, 5
。
SELECT * FROM xy WHERE num = '135' DESC LIMIT 0, 5
返回前5个给定集合
使用mysql limit
LIMIT子句,用于指定要返回的记录数
SELECT * FROM xy WHERE num = '135' ORDER BY column_name DESC LIMIT 5
SQL查询说"只返回5条记录,从记录0开始(OFFSET -1)"
SELECT * FROM xy WHERE num = '135' ORDER BY column_name DESC LIMIT 5 OFFSET -1