最近将一个用ASP+MS SQL的程序改成ASP+MYSQL的程序,遇到一个问题,就是MYSQL的语法和MS SQL的语法不一样!有以下几点不知道怎么改:
MS SQL语法:
SELECT Top 3 * FROM Goods ORDER BY id DESC
改为MYSQL语法:
SELECT * FROM Goods ORDER BY id DESC limit 3
是这样吧?第二处就不会了
MS SQL:
sql = "SELECT Top 3 * FROM Goods ORDER BY BuyCount DESC"
rs.Open sql, conn, 3, 3
上面这句怎么改?
谁知道,谢谢!
MS SQL语法:
SELECT Top 3 * FROM Goods ORDER BY id DESC
改为MYSQL语法:
SELECT * FROM Goods ORDER BY id DESC limit 3
是这样吧?第二处就不会了
MS SQL:
sql = "SELECT Top 3 * FROM Goods ORDER BY BuyCount DESC"
rs.Open sql, conn, 3, 3
上面这句怎么改?
谁知道,谢谢!
现在是这句:
MS SQL:
Select b.*,g.Name From Basket b,Goods g Where b.AdminChecked="&iflag&" And b.GoodsId=g.Id
请问MYSQL语法为:
????
MS SQL语法:
SELECT Top 3 * FROM Goods ORDER BY id DESC
改为MYSQL语法:
SELECT * FROM Goods ORDER BY id DESC limit 3这两个是否等价?