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
发布时间: 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