查询数据的数量
count()
查询数据的数量, 需要写在链路的末尾
- @param
isShowSql是否在控制台打印最终执行的SQL语句，默认不打印 - (isShowSql: boolean = false)
count()
import { Db } from 'think-ts-db'
export default defineEventHandler(async (event) => {
const user = await Db('user', mysqlConfig).where('age', '>', 10).count()
return user
})import { Db } from 'think-ts-db'
export default defineEventHandler(async (event) => {
const user = await Db('user', mysqlConfig).where('age', '>', 10).count()
return user
})最终的SQL语句为：
SELECT COUNT(*) FROM user WHERE age > 10SELECT COUNT(*) FROM user WHERE age > 10