mysql - 使用顶级查询时出现sql语法错误

Question

我正在为我的表使用顶级查询但遇到错误

You have an error in your sql syntax, chekck the manual that corresponds to your mysql server version for the right sytntax to use near '4 * from sitemain order by siteid desc limit 0,30' at line 1

这是我使用的代码

SELECT top 4 *
FROM sitemain
ORDER BY siteid DESC

Answer 1

您将 MySQL 和 TSQL 语法混合在一起。查询显然是 MySQL(来自错误消息)。你想要的是

SELECT * FROM sitemain ORDER BY siteid DESC LIMIT 0,4