Results of 1 - 10 of about 108 for Command (0.002 sec.)
- Dot Commands 13166
- 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
...e separated, after the command. If an argument must contain a space, either single or double quotes may be used to wrap that parameter. Dot commands must...gle line, and no whitespace may occur before the period. No semicolon is required at the end of the line. To see available commands, use the .help command. List of Dot Commands Command Description .about Prints version, description and license informati...to DIRECTORY .changes ⟨on/off⟩ Show number of rows changed by SQL .columns Column-wise rendering of query results .connect_command ⟨COMMAND⟩ Set the command executed by the -connect argument .databases List names and files of attached databases .decimal... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Command Line Client 12987
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...tHub Actions. Please see the installation page under the CLI tab for download links. The DuckDB CLI is based on the SQLite command line shell, so CLI-client-specific functionality is similar to what is described in the SQLite documentation (although Duc...le has been downloaded, decompress it and save it to any directory. Navigate to that directory in a terminal and enter the command duckdb to run the executable. If in a PowerShell or POSIX shell environment, use the command ./duckdb instead. Usage The t...ypical usage of the duckdb command is the following: duckdb ⟨OPTIONS⟩ ⟨FILENAME⟩ Options The ⟨OPTIONS⟩ part encodes arguments for the CLI client . Common opt... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Command Line Arguments 10933
- 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
...bail Stop after hitting an error -batch Force batch I/O -box Set output mode to box -column Set output mode to column -cmd COMMAND Run COMMAND before reading stdin -connect [TYPE[:SECRET]] Connect to a remote database. The default type is quack . A name...d secret can be provided after the type -c COMMAND Run COMMAND and exit -csv Set output mode to csv -dark-mode Use dark mode colors for syntax highlighting -echo Print comma...mode to quote -readonly Open the database read-only. This option also supports attaching to remote databases via HTTPS -s COMMAND Run COMMAND and exit -safe Enable safe mode -separator SEP Set output column separator to SEP . Default: | -serve [quack[:... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Output Formats 8394
- 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
...table tabs Tab-separated values tcl TCL list elements trash No output Changing the Output Format Use the vanilla .mode dot command to query the appearance currently in use. .mode current output mode: duckbox Use the .mode dot command with an argument to...g_ducks | |----------------------| | quacking intensifies | The output appearance can also be adjusted with the .separator command. If using an export mode that relies on a separator ( csv or tabs for example), the separator will be reset when the mode...ELECT 10 AS col1, 20 AS col_2; col_1|col_2 1|2 10|20 Paging The CLI supports paging for large result sets using the .pager command. When enabled, results that exceed the terminal size are displayed in a pager (such as less ) for easier navigation. The p... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- DuckDB Installation 8343
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install....ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO... - https://man.mtool.work/duckdb/2.0/installation.html
- DuckDB Installation 8343
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install....ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO... - https://man.mtool.work/duckdb/2.0/installation/
- installation_content.html 8343
- DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client documentation page curl https://install
...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install....ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO... - https://man.mtool.work/duckdb/2.0/installation_content.html
- Agent Mode 7986
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...output mode flag (such as -csv or -json ) was passed. You can also control agent mode explicitly: The -agent and -no-agent command line arguments force the mode on or off. The DUCKDB_AGENT_MODE environment variable forces the mode on ( 1 ) or off ( 0 )....The command line flags take precedence over the environment variable. To hide the startup line that announces agent mode, set .startup..._text none as the first line in ~/.duckdbrc . For example, to force agent mode on when running a single command: duckdb -agent -c "SELECT 42 AS answer;" To force it off: duckdb -no-agent -c "SELECT 42 AS answer;" Output Format In agen... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- SQL Introduction 7935
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...re listed on the PostgreSQL compatibility page . In the examples that follow, we assume that you have installed the DuckDB Command Line Interface (CLI) shell. See the installation page for information on how to install the CLI. Tip If you are looking fo...EGER, -- maximum temperature on a day prcp FLOAT, date DATE ); You can enter this into the shell with the line breaks. The command is not terminated until the semicolon. White space (i.e., spaces, tabs and newlines) can be used freely in SQL commands. T...hat means you can type the command aligned differently than above, or even all on one line. Two dash characters ( -- ) introduce comments. Whatever follows t... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
- MySQL Import 7514
- To run a query directly on a running MySQL database, the mysql extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL mysql; To load the mysql ex
...tension for usage, use the LOAD SQL command: LOAD mysql; Usage After the mysql extension is installed, you can attach to a MySQL database using the following command:... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
DuckDB 2.0 Documentation / man.mtool.work