Results of 1 - 3 of about 3 for shorthands (0.001 sec.)
- Dot Commands 11124
- 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
...ring_value green bold .highlight_colors footer gray The result highlighting can be disabled using .highlight_results off . Shorthands DuckDB's CLI allows using shorthands for dot commands. Once a sequence of characters can be unambiguously completed to a d...r an argument, the CLI (silently) autocompletes them. For example: .mo ma Is equivalent to: .mode markdown Tip Avoid using shorthands in SQL scripts to improve readability and ensure that the scripts are future-proof. Importing Data The .import command imp... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Sharing Macros 10026
- DuckDB has a powerful macro mechanism that allows creating shorthands for common tasks. Sharing a Scalar Macro First, we define a macro that pretty-prints a non-negative integer as a short string with thousands, millions, and billions (with
... - https://man.mtool.work/duckdb/2.0/guides/snippets/sharing_macros.html
- FROM and JOIN Clauses 6734
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...ing "AS my_alias") Adding the aliases allows the query to parse successfully: SELECT * FROM t AS t1 JOIN t AS t2 USING(x); Shorthands in the JOIN Clause You can specify column names in the JOIN clause: CREATE TABLE t1 (x INTEGER); CREATE TABLE t2 (y INTEGE... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work