Skip to main content

INSERT

Single insertion​

import { useD1 } from 'cl-orm';

const db = useD1(env.DB);

await db.insert({
  into: 'test',
  values: {
    column1: 'foo',
    column2: 1,
  },
});

SQL Query

INSERT INTO `test` (`column1`, `column2`) VALUES (?, ?)
-- params: ['foo', 1]

Multiple insertions​

import { useD1 } from 'cl-orm';

const db = useD1(env.DB);

await db.insert({
  into: 'test',
  values: [
    {
      column1: 'foo',
      column2: 1,
    },
    {
      column1: 'bar',
      column2: 2,
    },
  ],
});

SQL Query

INSERT INTO `test` (`column1`, `column2`) VALUES (?, ?), (?, ?)
-- params: ['foo', 1,  'bar', 2]