Create data: insert()

Perform an INSERT into a table or view.

Parameters

valuesobject | object[]Required

The values to write. Pass an array to write many rows in one request.

options.count'exact' | 'planned'

Count algorithm to use to count rows in the table or view.

options.defaultToNullboolean

Make missing fields default to null instead of the column default.

Is this helpful?

const { error } = await basalt
  .from('countries')
  .insert({ id: 1, name: 'Mordor' })

const { error } = await basalt
  .from('countries')
  .insert([
    { id: 1, name: 'Mordor' },
    { id: 2, name: 'The Shire' },
  ])

Is this helpful?

AI tools