<aside> <img src="/icons/aquarius_brown.svg" alt="/icons/aquarius_brown.svg" width="40px" />

참고

• https://orm.drizzle.team/docs/insert </aside>

리턴값

await db.insert(users).values({ name: "Dan" }).returning();

// 변형
await db.insert(users).values({ name: "Partial Dan" }).returning({ insertedId: users.id });

upsert

insert + onConflictDoUpdate를 쓰면 됨.

await db.insert(users)
  .values({ id: 1, name: 'Dan' })
  .onConflictDoUpdate({ target: users.id, set: { name: 'John' } });