sections: pages:pages-execute-write
This data as json
| id | page | ref | title | content | breadcrumbs | references |
|---|---|---|---|---|---|---|
| pages:pages-execute-write | pages | pages-execute-write | Write SQL queries | The /database-name/-/execute-write page can be used to execute SQL statements that write to a mutable database, if the execute-write-sql permission is enabled. This page extracts named parameters from the SQL, shows the tables that will be affected and lists the permissions required before the query can be executed. It also includes templates for common INSERT , UPDATE and DELETE statements. Datasette checks additional permissions based on the operations in the SQL. Row changes require the relevant table-level permissions such as insert-row , update-row and delete-row ; reads from source tables require view-table ; and schema changes require permissions such as create-table , alter-table or drop-table . Use the Executing write SQL JSON API to execute writable SQL programmatically. | ["Pages and API endpoints", "Queries"] | [] |