Skip to main content

UPDATE

For WHERE examples, please see the WHERE section.

Simple update​

import { useD1 } from 'cl-orm';

const db = useD1(env.DB);

await db.update({
  table: 'users',
  set: {
    name: 'John',
  },
});

SQL Query

UPDATE `users` SET `name` = ?
-- params: ['John']

Update multiple columns​

import { useD1 } from 'cl-orm';

const db = useD1(env.DB);

await db.update({
  table: 'users',
  set: {
    name: 'John',
    age: 29,
    // ...
  },
});

SQL Query

UPDATE `users` SET `name` = ?, `age` = ?
-- params: ['John', 29]