Results of 1 - 10 of about 34 for Passing (0.002 sec.)
- CREATE MACRO Statement 13804
- 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 v...gate function too. * A call to a table macro can appear in the FROM clause of a SELECT statement, or in a CALL statement . Passing Parameters Parameter values can be passed to the macro as a comma-separated list of expressions appearing between the pare...ntheses following the macro's name. Parameter values may be passed either positionally or by name. Positional parameter passing means that only the value expression is passed; In contrast to positional parameter passing, named parameter passing expli... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Connect 12302
- Connect or Create a Database To use DuckDB, you must first create a connection to a database. The exact syntax varies between the client APIs but it typically involves passing an argument to configure persistence. Since DuckDB 1.5.3, you ca
...see the storage page . In-Memory Database DuckDB can operate in in-memory mode. In most clients, this can be activated by passing the special value :memory: as the database file or omitting the database file argument. In in-memory mode, no data is pers... - https://man.mtool.work/duckdb/2.0/connect/overview.html
- Star Expression 11407
- Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from tha
...ressions don't currently support the pattern matching operators, but they do support regular expression matching by simply passing a string constant in place of the star: SELECT COLUMNS('(id|numbers?)') FROM numbers; id number 1 10 2 20 3 NULL Renaming...run: SELECT min(COLUMNS(*)) AS "min_\0" FROM numbers; min_id min_number 1 10 COLUMNS Lambda Function COLUMNS also supports passing in a lambda function . The lambda function is evaluated for all columns present in the FROM clause. Only columns for which...ename columns. SELECT COLUMNS(lambda c: c LIKE '%num%') FROM numbers; number 10 20 NULL COLUMNS List COLUMNS also supports passing in a list of column names. SELECT COLUMNS(['id', 'number']) FROM numbers; id number 1 10 2 20 3 NULL Unpacking a COLUMNS E... - https://man.mtool.work/duckdb/2.0/sql/expressions/star.html
- Command Line 10209
- Unexpected Markdown Output When Piping If the output of the command line client is piped to another process and an AI agent environment variable (such as AI_AGENT ) is set, the CLI switches to agent mode and prints compact Markdown tables i
...nment variable to 0 : echo "SELECT 42 AS x;" | duckdb -no-agent | cat ┌───────┐ │ x │ │ int32 │ ├───────┤ │ 42 │ └───────┘ Passing an explicit output mode flag, such as -csv or -json , also disables agent mode.... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/command_line.html
- CSV Auto Detection 8707
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...treated as fixed: the sniffer uses the value you provide and only detects the properties you did not specify. For example, passing ignore_errors = true lets the sniffer skip malformed lines while it detects the dialect. The auto_detect parameter must be...true (its default) for sniff_csv ; passing auto_detect = false results in an error. In addition, sniff_csv accepts a force_match ( BOOLEAN ) parameter that is not av... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- query and query_table Functions 8707
- The query_table and query functions enable powerful and more dynamic SQL. The query_table function returns the table whose name is specified by its string argument; the query function returns the table obtained by executing the query specif
...ied by its string argument. Both functions only accept constant strings. For example, they allow passing in a table name as a prepared statement parameter: CREATE TABLE my_table (i INTEGER); INSERT INTO my_table VALUES (42); PR... - https://man.mtool.work/duckdb/2.0/guides/sql_features/query_and_query_table_func...
- Debugging 8404
- The purpose of the tests is to figure out when things break. Inevitably changes made to the system will cause one of the tests to fail, and when that happens the test needs to be debugged. First, it is always recommended to run in debug mod
...the system using the command make debug . Second, it is recommended to only run the test that breaks. This can be done by passing the filename of the breaking test to the test suite as a command line parameter (e.g., build/debug/test/unittest test/sql/... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/debugging.html
- Dot Commands 8100
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...⟨NUM1⟩ ⟨NUM2⟩ ... Set minimum column widths for columnar output Using the .help Command The .help text may be filtered by passing in a text string as the first argument. .help m .manual FUNCTION Show the manual page for a SQL function Displays the sign...AS col_2 UNION ALL SELECT 10 AS col1, 20 AS col_2; The file my_output_file.csv will then contain: col_1,col_2 1,2 10,20 By passing special options (flags) to the .once command, query results can also be sent to a temporary file and automatically opened... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Command Line Arguments 7797
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...dot commands , e.g., in the ~/.duckdbrc file. By default, -serve calls quack_serve and -connect runs a CONNECT statement. Passing a Sequence of Arguments Note that the CLI arguments are processed in order, similarly to the behavior of the SQLite CLI. F... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Output Formats 7797
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...he pager can be configured: .pager set_row_threshold 50 .pager set_column_threshold 5 A custom pager command can be set by passing it as an argument: .pager less -RS The default pager command can also be configured via the DUCKDB_PAGER or PAGER environm... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
DuckDB 2.0 Documentation / man.mtool.work