SQL 删除
你可以删除表中的所有行：
await db.delete(users);你也可以使用过滤条件进行删除：
await db.delete(users).where(eq(users.name, 'Dan'));输出
在 PostgreSQL 中，你可以删除一行并将其取回：
const deletedUser = await db.delete(users)
.where(eq(users.name, 'Dan'))
.output();
// 部分返回
const deletedUserId = await db.delete(users)
.where(eq(users.name, "Dan"))
.output({ deletedId: users.id });
// deletedUserId: { deletedId: number }[]delete from [users] output DELETED.[id], DELETED.[name], DELETED.[age] where [users].[name] = 'Dan'
delete from [users] output DELETED.[id] where [users].[name] = 'Dan'