如题SQL server:"SELECT TOP " + j1 + "* FROM bbs WHERE parentid=0 and boardid=" + i1 + " ORDER BY dateandtime DESC";可以运行!
mysql该如何实现?
"SELECT * FROM bbs limit 0,"+j1+" WHERE parentid=0 and boardid=" + i1 + " ORDER BY dateandtime DESC";不能运行!
mysql该如何实现?
"SELECT * FROM bbs limit 0,"+j1+" WHERE parentid=0 and boardid=" + i1 + " ORDER BY dateandtime DESC";不能运行!
取10条记录
select * from tb_shop id order by id desc limit 0,1
取1条记录