Results of 1 - 10 of about 96 for Parameters (0.006 sec.)
- Complete API 11596
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...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/2.0/clients/c/api.html
- Values 10742
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...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/2.0/clients/c/value.html
- ODBC Extension Functions 10414
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...ransaction. The completion starts another implicit transaction on this connection. See Transaction management for details. Parameters: conn_handle ( BIGINT ): ODBC connection handle created with odbc_connect Returns: Always returns NULL ( VARCHAR ). Exampl...arams(conn_handle BIGINT, params_handle BIGINT, params STRUCT) -> BIGINT Binds specified parameter values to the specified parameters handle. Only necessary with 2-step parameters binding, see Query parameters for details. Parameters: conn_handle ( BIGINT...): ODBC connection handle created with odbc_connect params_handle ( BIGINT ): parameters handle created with odbc_create_params params ( STRUCT ): parameters values Returns: Parameters handle ( BIGINT ), the sam... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Types 10020
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...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/2.0/clients/c/types.html
- Table Functions 9888
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...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/2.0/clients/c/table_functions.html
- Prepared Statements 9823
- DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared
...( $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 Dataset In the following, we introduce the three different syntaxes and illustrate them wi...ple whose name starts with a B and are at least 40 years old. This will return a single row <'Bob', 41> . Auto-Incremented Parameters: ? DuckDB supports using prepared statements with auto-incremented indexing, i.e., the position of the parameters in the q...me, ?) AND age >= ?; Using the CLI client, the statement is executed as follows. EXECUTE query_person('B', 40); Positional Parameters: $1 Prepared statements can use positional parameters, where parameters are denoted with an integer ( $1 , $2 ). For examp... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
- CREATE MACRO Statement 9823
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...by passing values to its parameters; this causes its expression to be evaluated, yielding a value. Depending on the macro type, the value may be scalar, or a...CRO . The simplified syntax for creating a macro is: CREATE [OR REPLACE] [TEMPORARY] MACRO [IF NOT EXISTS] ⟨identifier⟩( [⟨parameters⟩] ) AS [TABLE] ⟨expression⟩; The identifier consists of the macro's name, which can be any valid SQL identifier. A macro m...LACE or the IF NOT EXISTS clause may be present, but not both. The macro name is followed by parentheses. If the macro has parameters , then they must be declared within the parentheses. The AS keyword appears after the right parenthesis but before the exp... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Relational API 9691
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...te 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 from...self: _duckdb.DuckDBPyConnection, arrow_object: object) -> DuckDBPyRelation Create a relation object from an Arrow object. Parameters arrow_object : object The Arrow object to create a relation from: a table, a record batch, a record batch reader, a datase...om_df(self: _duckdb.DuckDBPyConnection, df: object) -> DuckDBPyRelation Create a relation object from the DataFrame in df. Parameters df : pandas.DataFrame A pandas DataFrame to be converted into a DuckDB relation. Example import duckdb import pandas as pd... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Prepared Statements 9232
- A prepared statement 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...an up duckdb_destroy_result(&result); duckdb_destroy_prepare(&stmt); After calling duckdb_prepare , the prepared statement parameters can be inspected using duckdb_nparams and duckdb_param_type . In case the prepare fails, the error can be obtained through... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Startup & Shutdown 8273
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory databas
...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/2.0/clients/c/connect.html
DuckDB 2.0 Documentation / man.mtool.work