Neon•15mo ago

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}`

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}`

No replies yetBe the first to reply to this messageJoin

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

Similar Threads

Similar Threads

Similar Threads