Results of 1 - 10 of about 82 for Command (0.005 sec.)
- CLI Client – DuckDB 14862
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...ent APIs / CLI Copy Markdown CLI Client The latest version of the DuckDB CLI client is 1.5.6. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable. It is precompiled for Windows, Mac, and Linux for both the stable...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... - https://man.mtool.work/duckdb/1.3/clients/cli/overview.html
- Dot Commands – DuckDB 12301
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...w Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Client APIs / CLI Copy Markdown Dot Commands Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) imm...ediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, space separated, after the command. If an argument m... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Command Line Arguments – DuckDB 10802
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...rview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Client APIs / CLI Copy Markdown Command Line Arguments 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 -append Append the database to the end of th... - https://man.mtool.work/duckdb/1.3/clients/cli/arguments.html
- SQL Introduction – DuckDB 8950
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...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. Concepts DuckDB is a rela...ER , -- 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.... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- Output Formats – DuckDB 8309
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...rmat Execution Format Pivot Sitemap Live Demo Documentation / Client APIs / CLI Copy Markdown Output Formats The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appeara...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... - https://man.mtool.work/duckdb/1.3/clients/cli/output_formats.html
- EXPORT and IMPORT DATABASE Statements – DuckDB 8023
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...Sitemap Live Demo Documentation / SQL / Statements Copy Markdown EXPORT and IMPORT DATABASE Statements The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then...s, see the Parquet Files page in the Data Import section and the COPY Statement page . EXPORT DATABASE The EXPORT DATABASE command exports the full contents of the database – including schema information, tables, views and sequences – to a specific dire... - https://man.mtool.work/duckdb/1.3/sql/statements/export.html
- Hugging Face Support – DuckDB 7737
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...y: SELECT * FROM 'hf://datasets/datasets-examples/doc-formats-parquet-1/data/train-00000-of-00001.parquet' ; Each of these commands reads the data from the specified file format and displays it in a structured tabular format. Choose the appropriate comm...id accessing the remote endpoint for every query, you can save the data in a DuckDB table by running a CREATE TABLE ... AS command . For example: CREATE TABLE data AS SELECT * FROM 'hf://datasets/datasets-examples/doc-formats-csv-1/data.csv' ; Then, sim... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/hugging_face.html
- UI Extension – DuckDB 7737
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...Requirements An environment with a browser. Any DuckDB client except Wasm, v1.2.1 or later. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui (); Running either of these will open the UI in your default brow...plicitly and sign into MotherDuck. Configuration Local Port The local port of the HTTP server can be configured with a SQL command like: SET ui_local_port = 4213 ; The environment variable ui_local_port can also be used. The default port is 4213. (Why?... - https://man.mtool.work/duckdb/1.3/core_extensions/ui.html
- MySQL Import – DuckDB 7669
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...L 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 extension for usage, use the LOAD SQL command: LOAD mys...ql ; Usage After the mysql extension is installed, you can attach to a MySQL database using the following command: ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db ( TYPE mysql , READ_ONLY ); USE mysql_db ; The... - https://man.mtool.work/duckdb/1.3/guides/database_integration/mysql.html
- SQLite Import – DuckDB 7669
- 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
...s Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Safe Mode Autocomplete Syntax Highlighting Known Issues Dart Go Java (JDBC) Julia Node.js (Depreca...Lite file, the sqlite extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL sqlite ; To load the sqlite extension for usage, use the LOAD SQL command: LOAD s....db" SELECT * FROM sqlite_scan ( 'test.db' , 'tbl_name' ); Alternatively, the entire file can be attached using the ATTACH command. This allows you to query all tables stored within a SQLite database file as if they were a regular database. -- Attach th... - https://man.mtool.work/duckdb/1.3/guides/database_integration/sqlite.html
DuckDB 1.3 Documentation / man.mtool.work