Results of 1 - 10 of about 41 for replace (0.004 sec.)
- Regular Expressions – DuckDB 14936
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl.... regexp_matches(string, pattern[, options]) Returns true if string contains the regexp pattern , false otherwise. regexp_replace(string, pattern, replacement[, options]) If string contains the regexp pattern , replaces the matching part with replaceme...nt . By default, only the first occurrence is replaced. A set of optional options , including the global flag g , can be set. regexp_split_to_array(string, regex[, options]) Al... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Star Expression – DuckDB 10009
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...3 EXCLUDE Clause EXCLUDE allows you to exclude specific columns from the * expression. SELECT * EXCLUDE ( col ) FROM tbl ; REPLACE Clause REPLACE allows you to replace specific columns by alternative expressions. SELECT * REPLACE ( col1 / 1_000 AS col1..., col2 / 1_000 AS col2 ) FROM tbl ; RENAME Clause RENAME allows you to replace specific columns. SELECT * RENAME ( col1 AS height , col2 AS width ) FROM tbl ; Column Filtering via Pattern Matching Oper... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- S3 API Support – DuckDB 9900
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...ovider, config (i.e., user-configured), allows access to the S3 bucket by manually providing a key. For example: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER config , KEY_ID ' AKIAIOSFODNN7EXAMPLE ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMP...fetching credentials using mechanisms provided by the AWS SDK. For example, to use the AWS SDK default provider: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER credential_chain ); Again, to query a file using the above secret, simply query any s3:... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
- CREATE VIEW Statement – DuckDB 9807
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...t defines a new view in the catalog. Examples Create a simple view: CREATE VIEW v1 AS SELECT * FROM tbl ; Create a view or replace it if a view with that name already exists: CREATE OR REPLACE VIEW v1 AS SELECT 42 ; Create a view and replace the column...The view is not physically materialized. Instead, the query is run every time the view is referenced in a query. CREATE OR REPLACE VIEW is similar, but if a view of the same name already exists, it is replaced. If a schema name is given then the view is... - https://man.mtool.work/duckdb/1.3/sql/statements/create_view.html
- CREATE TABLE Statement – DuckDB 9605
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...egular database tables. In these cases, use their fully qualified name, e.g., temp.main.t1 , for disambiguation. CREATE OR REPLACE The CREATE OR REPLACE syntax allows a new table to be created or for an existing table to be overwritten by the new table....able and then creating the new one. Create a table with two integer columns (i and j) even if t1 already exists: CREATE OR REPLACE TABLE t1 ( i INTEGER , j INTEGER ); IF NOT EXISTS The IF NOT EXISTS syntax will only proceed with the creation of the tabl... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- Friendly SQL – DuckDB 9403
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...ted in other systems while some are (currently) exclusive to DuckDB. Clauses Creating tables and inserting data: CREATE OR REPLACE TABLE : avoid DROP TABLE IF EXISTS statements in scripts. CREATE TABLE ... AS SELECT (CTAS) : create a new table from the...OR IGNORE INTO ... : insert the rows that do not result in a conflict due to UNIQUE or PRIMARY KEY constraints. INSERT OR REPLACE INTO ... : insert the rows that do not result in a conflict due to UNIQUE or PRIMARY KEY constraints. For those that resul... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- Functions – DuckDB 9403
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...on call fn(arg1, arg2, arg3, ...) to be rewritten as arg1.fn(arg2, arg3, ...) . For example, take the following use of the replace function : SELECT replace ( goose_name , 'goose' , 'duck' ) AS duck_name FROM unnest ([ 'African goose' , 'Faroese goose'..., 'Hungarian goose' , 'Pomeranian goose' ]) breed ( goose_name ); This can be rewritten as follows: SELECT goose_name. replace ( 'goose' , 'duck' ) AS duck_name FROM unnest ([ 'African goose' , 'Faroese goose' , 'Hungarian goose' , 'Pomeranian goose... - https://man.mtool.work/duckdb/1.3/sql/functions/overview.html
- CASE Expression – DuckDB 8890
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...ELSE b END is equivalent to cond ? a : b ). With a single condition this can be expressed with IF(cond, a, b) . CREATE OR REPLACE TABLE integers AS SELECT unnest ([ 1 , 2 , 3 ]) AS i ; SELECT i , CASE WHEN i > 2 THEN 1 ELSE 0 END AS test FROM integers...r any of the conditions returns true for a single tuple, the corresponding expression is evaluated and returned. CREATE OR REPLACE TABLE integers AS SELECT unnest ([ 1 , 2 , 3 ]) AS i ; SELECT i , CASE WHEN i = 1 THEN 10 WHEN i = 2 THEN 20 ELSE 0 END AS... - https://man.mtool.work/duckdb/1.3/sql/expressions/case.html
- INSERT Statement – DuckDB 8890
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...hing on conflict: INSERT OR IGNORE INTO tbl ( i ) VALUES ( 1 ); Or update the table with the new values instead: INSERT OR REPLACE INTO tbl ( i ) VALUES ( 1 ); Syntax INSERT INTO inserts new rows into a table. One can insert one or more rows specified b...l BY NAME ( SELECT 1 AS i , 336 AS j ) ON CONFLICT DO UPDATE SET j = EXCLUDED .j ; SELECT * FROM tbl ; i j 1 336 INSERT OR REPLACE INTO The INSERT OR REPLACE INTO ... statement is a shorter syntax alternative to INSERT INTO ... DO UPDATE SET c1 = EXCLUD... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- AWS Extension – DuckDB 8595
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highl...ovider, config (i.e., user-configured), allows access to the S3 bucket by manually providing a key. For example: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER config , KEY_ID ' AKIAIOSFODNN7EXAMPLE ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMP...fetching credentials using mechanisms provided by the AWS SDK. For example, to use the AWS SDK default provider: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER credential_chain ); Again, to query a file using the above secret, simply query any s3:... - https://man.mtool.work/duckdb/1.3/core_extensions/aws.html
DuckDB 1.3 Documentation / man.mtool.work