Results of 1 - 6 of about 6 for placeholders (0.001 sec.)
- Run Queries 11826
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
...RY KEY DEFAULT NEXTVAL('seq'), name TEXT NOT NULL, data BLOB );", )?; Binding Parameters Values are bound to a statement's placeholders rather than formatted into the SQL string. DuckDB uses positional ( ? ) and numbered ( ?1 , ?2 ) placeholders. The params!...conn.execute( "INSERT INTO person (id, name, data) VALUES (?, ?, ?)", params![1, "Steven", None::<Vec<u8>>], )?; For named placeholders such as $name , use the named_params! macro: use duckdb::named_params; conn.query_row( "SELECT $age >= 18 AND $name = 'Ali... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- Run Queries 11534
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...l(err) } n, _ := res.RowsAffected() log.Printf("inserted %d rows", n) Binding Parameters Values are bound to a statement's placeholders rather than formatted into the SQL string, which avoids SQL injection and lets DuckDB reuse a plan. DuckDB accepts positio...nal ( ? ) and numbered ( $1 , $2 ) placeholders; pass the values as trailing arguments in order: rows, err := db.QueryContext(ctx, ` SELECT name, age FROM users WHERE (na...me = ? OR name = ?) AND age > ?`, "macgyver", "marc", 30, ) For named placeholders such as $name , wrap each argument with sql.Named : row := db.QueryRowContext(ctx, "SELECT $age >= 18 AND $name = 'Alice'"... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- ODBC Extension Functions 8353
- 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) ->
...) dest_query ( VARCHAR ): query to be executed in remote DB for each source batch, must have the number of ODBC parameter placeholders ? equal to the source_columns_count * batch_size , cannot be specified if dest_table is specified, example: CALL import_ci...urce batch are less than the batch_size , in this case used instead of dest_query , must have the number of ODBC parameter placeholders ? equal to the source_columns_count Optional named parameters (create table): create_table ( BOOLEAN , default: FALSE ): w... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Appender 7787
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...without running it. Invalid SQL, incorrect column counts, unsupported statement types, RETURNING clauses and SQL parameter placeholders such as ? raise an exception at creation. These errors leave the transaction usable. Cast errors and constraint violations... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- FILTER Clause 7787
- The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function in the same way that a WHERE clause filters rows, but localized to the specific
...and array_agg , FILTER excludes rows that do not satisfy its condition, whereas a CASE WHEN expression can contribute NULL placeholders for those rows. However, FILTER does not automatically remove NULL values from rows that do satisfy the condition. To omit... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/filter.html
- Python DB API 7494
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...s are not case sensitive: the key "ABC" binds $abc , so do not pass two keys that differ only in case. Insert a row with ? placeholders, and several rows with executemany() , which runs the statement once for each list of values: con.execute("INSERT INTO ite... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work