限定查询数量
Limit()
限制查询的条数,一般为了语义化会写在所有条件之后,Select()
FindOne()
之前
- @param
num
要查询的条数
Limit()
var user []User
err := tg.Db("user").Where("age", ">", 10).Limit(10).Select()
var user []User
err := tg.Db("user").Where("age", ">", 10).Limit(10).Select()
最终的SQL语句为:
SELECT * FROM user WHERE age > 10 LIMIT 10
SELECT * FROM user WHERE age > 10 LIMIT 10