读书人

MSSQL这句如何翻译成MYSQL

发布时间: 2012-10-18 13:46:55 作者: rapoo

MSSQL这句怎么翻译成MYSQL
SELECT * FROM FoodMenu top & where id not in (select id from FoodMenu top &)

注:&为展位符,在一个页面中要多少个菜信息

[解决办法]
select * from table1 order by id limit 100,10;
[解决办法]
select *
from FoodMenu
order by id desc
limit n,m

读书人网 >Mysql

热点推荐