如何列出sql中的最后10行?
我以前用过"SELECT * FROM event ORDER BY ID DESC LIMIT 1"
,它对我很有效,我想玩它可能会起作用。
我用"SELECT * FROM event ORDER BY ID DESC LIMIT 10"
"SELECT TOP 10 * FROM event ORDER BY ID DESC LIMIT 1"
and "SELECT * FROM event ORDER BY ID DESC LIMIT 10,999999"但是不工作
这是PHP文件
<?php
$con=mysqli_connect("rock","mido","1234","fyp");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM event ORDER BY ID DESC LIMIT 1");
$row = mysqli_fetch_array($result) ;
{
echo $row['EventName'] . $row['Date'] . $row['Time'] . $row['Venue'] . $row['Note'];
}
mysqli_close($con);
?>
和最重要的是,有没有办法让显示一个接一个?我应该尝试marquee
与它吗?
试试这个查询:
SELECT * FROM event ORDER BY ID LIMIT 10 OFFSET (SELECT COUNT(*) - 11 FROM event);
我认为最简单的方法是改变order by
:
SELECT *
FROM event
ORDER BY ID ASC
LIMIT 10;
如果您希望它们按id
降序排序,您可以使用子查询:
SELECT *
FROM (SELECT *
FROM event
ORDER BY ID ASC
LIMIT 10
) e
ORDER BY ID DESC;