Search Result: multiplier - DuckDB 2.0 全文検索

Prepared Statements 9414: 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 ... ion variable of the same name, if one is set. An explicit argument always takes precedence over the variable. SET VARIABLE multiplier = 10; SET VARIABLE x = 42; PREPARE compute AS SELECT $multiplier * $x AS result; With no arguments, both parameters come f ... Supplying an argument overrides the matching variable, while omitted parameters still fall back to theirs: EXECUTE compute(multiplier := 3); result 126 Because the fallback is resolved at execution time, re-executing the statement after changing a variable ... picks up the new value: SET VARIABLE multiplier = 100; EXECUTE compute; result 4200 The fallback applies to named parameters only. Auto-incremented ( ? ) and positional ( ...; https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work