N
Neon•12mo ago
stormy-gold

How to insert multiple rows at once using sql`...` from @neondatabase/serverless ?

I have an array of 3 row values I'd like insert in a single sql command. I can't find syntax that doesn't fail. Anyone has an example? 
import { neon } from "@neondatabase/serverless";
const sql = neon(Bun.env.DATABASE_URL);

const data = [
  ["david", 34],
  ["sam", 12],
  ["jane", 25"]
];

// What should be values here?
await sql`INSERT INTO users (name, age) VALUES ${values}`
import { neon } from "@neondatabase/serverless";
const sql = neon(Bun.env.DATABASE_URL);

const data = [
  ["david", 34],
  ["sam", 12],
  ["jane", 25"]
];

// What should be values here?
await sql`INSERT INTO users (name, age) VALUES ${values}`
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?