Results of 1 - 10 of about 37 for executed (0.008 sec.)
- Prepared Statements – DuckDB 13560
- 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
...x 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 . Syntax There are three syntaxes for denoting p...query_person AS SELECT * FROM person WHERE starts_with ( name , ? ) 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...ry_person AS SELECT * FROM person WHERE starts_with ( name , $ 2 ) AND age >= $ 1 ; Using the CLI client, the statement is executed as follows. Note that the first parameter corresponds to $1 , the second to $2 , and so on. EXECUTE query_person ( 40 , 'B... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/prepared_statements.html
- Prepared Statements – DuckDB 11886
- 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
...ating 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: Ea...supply parameters to functions while 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..._prepared_statement prepared_statement ); duckdb_prepared_statement_type Returns the statement type of the statement to be executed Syntax duckdb_statement_type duckdb_prepared_statement_type ( duckdb_prepared_statement statement ); Parameters statement... - https://man.mtool.work/duckdb/1.3/clients/c/prepared.html
- EXPLAIN: Inspect Query Plans – DuckDB 11886
- 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
...ery Plans EXPLAIN SELECT * FROM tbl ; The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed, and is enabled by prepending the query with EXPLAIN . The physical plan is a tree of operators that are executed in a spe...D name IS NOT NULL │ │ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ │ │ EC: 1 │ └───────────────────────────┘ Note that the query is not actually executed – therefore, we can only see the estimated cardinality ( EC ) for each operator, which is calculated by using the statisti...l' ; See Also For more information, see the ”Profiling” page . 関連キーワード ││ physical plan query students exams output executed explain optimized statement operator settings Shows Documentation Guides Meta Queries Copy Markdown Inspect Query Plans di... - https://man.mtool.work/duckdb/1.3/guides/meta/explain.html
- Executing SQL in Python – DuckDB 10939
- 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
...on Format Pivot Sitemap Live Demo Documentation / Guides / Python Copy Markdown Executing SQL in Python SQL queries can be executed using the duckdb.sql function. import duckdb duckdb . sql ( "SELECT 42" ). show () By default this will create a relation...ram. A connection to a persistent database can be created using the connect function. After connecting, SQL queries can be executed using the sql command. con = duckdb . connect ( "file.db" ) con . sql ( "CREATE TABLE integers (i INTEGER)" ) con . sql (...tegers VALUES (42)" ) con . sql ( "SELECT * FROM integers" ). show () 関連キーワード duckdb using results integers queries executed show default example fetchall used convert objects print connection connect Documentation Guides Copy Markdown Executing i... - https://man.mtool.work/duckdb/1.3/guides/python/execute_sql.html
- Debugging – DuckDB 8792
- 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
...by placing mode skip in the file, followed by an optional mode unskip . Any queries between the two statements will not be executed. Triggering Which Tests to Run When running the unittest program, by default all the fast tests are run. A specific test c...gle test: build/debug/test/unittest test /sql/projection/test_simple_projection.test All tests in a given directory can be executed by providing the directory as a parameter with square brackets. To run all tests in the “projection” directory: build/debu... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/debugging.html
- ADBC Client – DuckDB 8555
- 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
...tion: Function name Description Arguments Example StatementSetSqlQuery Set the SQL query to execute. The query can then be executed with StatementExecuteQuery. (AdbcStatement*, const char*, AdbcError*) AdbcStatementSetSqlQuery(&adbc_statement, "SELECT *...FROM TABLE", &adbc_error) StatementSetSubstraitPlan Set a substrait plan to execute. The query can then be executed with StatementExecuteQuery. (AdbcStatement*, const uint8_t*, size_t, AdbcError*) AdbcStatementSetSubstraitPlan(&adbc_state...tatement, &arrow_stream, &rows_affected, &adbc_error) StatementPrepare Turn this statement into a prepared statement to be executed multiple times. (AdbcStatement*, AdbcError*) AdbcStatementPrepare(&adbc_statement, &adbc_error) Functions related to bindi... - https://man.mtool.work/duckdb/1.3/clients/adbc.html
- Relational API – DuckDB 8555
- 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
...an be seen as symbolic representations of SQL queries. Lazy Evaluation The relations do not hold any data – and nothing is executed – until a method that triggers execution is called. For example, we create a relation, which loads 1 billion rows: import...SQL query, otherwise run the query as-is. Aliases : query , sql Parameters query : object The SQL query or subquery to be executed and converted into a relation. alias : str, default: '' Optional alias name to assign to the resulting relation. params :...query, otherwise run the query as-is. Aliases : from_query , sql Parameters query : object The SQL query or subquery to be executed and converted into a relation. alias : str, default: '' Optional alias name to assign to the resulting relation. params :... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Multiple Python Threads – DuckDB 8555
- 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
...VARCHAR, insert_time TIMESTAMP DEFAULT current_timestamp ) """ ) Reader and Writer Functions Next, define functions to be executed by the writer and reader threads. Each thread must use the .cursor() method to create a thread-local connection to the sam...will be kicked off in a random order to simulate simultaneous writers and readers. Note that the threads have not yet been executed, only defined. write_thread_count = 50 read_thread_count = 5 threads = [] # Create multiple writer and reader threads (in... - https://man.mtool.work/duckdb/1.3/guides/python/multiple_threads.html
- Complete API – DuckDB 7845
- 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 column type of the specified column. duckdb_result_statement_type Returns the statement type of the statement that was executed Syntax duckdb_statement_type duckdb_result_statement_type ( duckdb_result result ); Parameters result : The result object..._prepared_statement prepared_statement ); duckdb_prepared_statement_type Returns the statement type of the statement to be executed Syntax duckdb_statement_type duckdb_prepared_statement_type ( duckdb_prepared_statement statement ); Parameters statement...s, and returns a pending result. The pending result represents an intermediate structure for a query that is not yet fully executed. The pending result can be used to incrementally execute a query, returning control to the client between tasks. Note that... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- R-Tree Indexes – DuckDB 7845
- 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
...fetched from disk, and the often much more expensive exact spatial predicate check (and any other filters) only have to be executed for these rows. What Are the Limitations of R-Tree Indexes in DuckDB? Before you get started using the R-tree index, there...ing time). This is because the query planner needs to know the bounding box of the query region before the query itself is executed in order to use the R-tree index scan. In the future we want to enable R-tree indexes to be used to accelerate additional... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
DuckDB 1.3 Documentation / man.mtool.work