Results of 1 - 5 of about 5 for modifies (0.001 sec.)
- SET and RESET Statements 12391
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- UPDATE Statement 9725
- The UPDATE statement modifies the values of rows in a table. Examples For every row where i is NULL , set the value to 0 instead: UPDATE tbl SET i = 0 WHERE i IS NULL; Set all values of i to 1 and all values of j to 2: UPDATE tbl SET i = 1,
... - https://man.mtool.work/duckdb/2.0/sql/statements/update.html
- CREATE TRIGGER Statement 8824
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
...y statement that modifies a table in an audit table using a statement-level AFTER trigger. The REFERENCING OLD TABLE and NEW TABLE clauses expose th... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- SQLite Extension 7942
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...ons can then be read using SQLite. Concurrency DuckDB can read or modify a SQLite database while DuckDB or SQLite reads or modifies the same database from a different thread or a separate process. More than one thread or process can read the SQLite datab... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- ALTER TABLE Statement 7041
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...AULT 10; Drop the default value of a column: ALTER TABLE integers ALTER COLUMN i DROP DEFAULT; The SET/DROP DEFAULT clause modifies the DEFAULT value of an existing column. Note that this does not modify any existing data in the column. Dropping the defa... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work