Results of 1 - 10 of about 65 for parameters (0.008 sec.)
- Complete API – DuckDB 12481
- 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
...ce_cache instance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); Parameters instance_cache : The instance cache in which to create the database, or from which to take the database. path : Path to th...e cache and de-allocates its memory. Syntax void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); Parameters instance_cache : The instance cache to destroy. duckdb_open Creates a new database or opens an existing database file stor...ust be closed with 'duckdb_close'. Syntax duckdb_state duckdb_open ( const char * path , duckdb_database * out_database ); Parameters path : Path to the database file on disk. Both nullptr and :memory: open an in-memory database. out_database : The result... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Values – DuckDB 11508
- 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
...the value and de-allocates all memory allocated for that type. Syntax void duckdb_destroy_value ( duckdb_value * value ); Parameters value : The value to destroy. duckdb_create_varchar Creates a value from a null-terminated string Syntax duckdb_value duck...db_create_varchar ( const char * text ); Parameters text : The null-terminated string Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create...ength Creates a value from a string Syntax duckdb_value duckdb_create_varchar_length ( const char * text , idx_t length ); Parameters text : The text length : The length of the text Return Value The value. This must be destroyed with duckdb_destroy_value .... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Types – DuckDB 10835
- 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
...ks there are in the result. Syntax duckdb_data_chunk duckdb_result_get_chunk ( duckdb_result result , idx_t chunk_index ); Parameters result : The result object to fetch the data chunk from. chunk_index : The chunk index to fetch from. Return Value The res...if the type of the internal result is StreamQueryResult. Syntax bool duckdb_result_is_streaming ( duckdb_result result ); Parameters result : The result object to check. Return Value Whether or not the result object is of the type StreamQueryResult duckdb...Returns the number of data chunks present in the result. Syntax idx_t duckdb_result_chunk_count ( duckdb_result result ); Parameters result : The result object Return Value Number of data chunks present in the result. duckdb_result_return_type Returns the... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Table Functions – DuckDB 10621
- 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
...oys the given table function object. Syntax void duckdb_destroy_table_function ( duckdb_table_function * table_function ); Parameters table_function : The table function to destroy duckdb_table_function_set_name Sets the name of the given table function. S...yntax void duckdb_table_function_set_name ( duckdb_table_function table_function , const char * name ); Parameters table_function : The table function name : The name of the table function duckdb_table_function_add_parameter Adds a param...tion. Syntax void duckdb_table_function_add_parameter ( duckdb_table_function table_function , duckdb_logical_type type ); Parameters table_function : The table function. type : The parameter type. Cannot contain INVALID. duckdb_table_function_add_named_pa... - https://man.mtool.work/duckdb/1.3/clients/c/table_functions.html
- Relational API – DuckDB 10477
- 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
...ate a relation object for the named table table_function Create a relation object from the named table function with given parameters values Create a relation object from the passed values view Create a relation object for the named view from_arrow Signatu..., arrow_object : object ) -> duckdb . duckdb . DuckDBPyRelation Description Create a relation object from an Arrow object Parameters arrow_object : pyarrow.Table, pyarrow.RecordBatch Arrow object to create a relation from Example import duckdb import pyar...-> duckdb . duckdb . DuckDBPyRelation Description Create a relation object from the CSV file in 'name' Aliases : read_csv Parameters path_or_buffer : Union[str, StringIO, TextIOBase] Path to the CSV file or buffer to read from. header : Optional[bool], Op... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Prepared Statements – DuckDB 9690
- 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
...p Live Demo Documentation / SQL / Query Syntax Copy Markdown Prepared Statements DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syn...tax There are three syntaxes for denoting parameters in prepared statements: auto-incremented ( ? ), positional ( $1 ), and named ( $param ). Note that not all clients support...all of these syntaxes, e.g., the JDBC client only supports auto-incremented parameters in prepared statements. Example Data Set In the following, we introduce the three different syntaxes and illustrate them w... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/prepared_statements.html
- CREATE MACRO Statement – DuckDB 9361
- 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
...n) in the catalog. A macro may only be a single SELECT statement (similar to a VIEW ), but it has the benefit of accepting parameters. For a scalar macro, CREATE MACRO is followed by the name of the macro, and optionally parameters within a set of parenthe...e an alias, FUNCTION : CREATE FUNCTION main. my_avg ( x ) AS sum ( x ) / count ( x ); Create a macro with default constant parameters: CREATE MACRO add_default ( a , b : = 5 ) AS a + b ; Create a macro arr_append (with a functionality equivalent to array_a...end ): CREATE MACRO arr_append ( l , e ) AS list_concat ( l , list_value ( e )); Table Macros Create a table macro without parameters: CREATE MACRO static_table () AS TABLE SELECT 'Hello' AS column1 , 'World' AS column2 ; Create a table macro with paramete... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- Prepared Statements – DuckDB 9332
- 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
...tatement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement can be executed using those...parameters. A single query can be prepared once and executed many times. Prepared statements are useful to: Easily supply parameters...e avoiding string concatenation/SQL injection attacks. Speeding up queries that will be executed many times with different parameters. DuckDB supports prepared statements in the C API with the duckdb_prepare method. The duckdb_bind family of functions is u... - https://man.mtool.work/duckdb/1.3/clients/c/prepared.html
- Startup & Shutdown – DuckDB 8402
- 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
...ce_cache instance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); Parameters instance_cache : The instance cache in which to create the database, or from which to take the database. path : Path to th...e cache and de-allocates its memory. Syntax void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); Parameters instance_cache : The instance cache to destroy. duckdb_open Creates a new database or opens an existing database file stor...ust be closed with 'duckdb_close'. Syntax duckdb_state duckdb_open ( const char * path , duckdb_database * out_database ); Parameters path : Path to the database file on disk. Both nullptr and :memory: open an in-memory database. out_database : The result... - https://man.mtool.work/duckdb/1.3/clients/c/connect.html
- Query – DuckDB 8216
- 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
...APIs / C Copy Markdown Query The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the applicatio...ctly. Syntax duckdb_state duckdb_query ( duckdb_connection connection , const char * query , duckdb_result * out_result ); Parameters connection : The connection to perform the query in. query : The SQL query to run. out_result : The query result. Return V...esult and de-allocates all memory allocated for that result. Syntax void duckdb_destroy_result ( duckdb_result * result ); Parameters result : The result to destroy. duckdb_column_name Returns the column name of the specified column. The result should not... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
DuckDB 1.3 Documentation / man.mtool.work