TOP和ORDER BY sql错误 [英] TOP and ORDER BY sql error

问题描述

我正在尝试使用PHP从MySQL的表中选择最后一条记录.我相信我有一个SQL错误.这是我的SQL代码:

I am trying to select the last record from a table in MySQL using PHP. I believe I have an SQL error. Here is my SQL code:

SELECT TOP 1 id FROM `table` ORDER BY id DESC

如果这是有效的，并且我确实有PHP错误，请告诉我.

If this is valid and I actually have a PHP error, tell me.

推荐答案

您的SQL语法无效.使用 LIMIT

you have an invalid sql syntax. use LIMIT instead

尝试一下:

SELECT id 
FROM table 
ORDER BY id DESC
LIMIT 1

TOP子句在MSSQL服务器上有效.

the TOP clause works on MSSQL server.

这篇关于TOP和ORDER BY sql错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！