select top 1 * from [tablename] order by ID desc 报错
SELECT top 1 * FROM version_manage where title ='mes' order by version desc
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 * FROM version_manage where title ='mes' order by version desc' at line 1
> 时间: 0.041s
top 1 是sqlserver的语法,mysql的要用limit来做,而oracle的就是 rownum<2了。
MySQL中应改为:
select * from table1 order by id limit 1;