Results of 1 - 10 of about 12 for property (0.009 sec.)
- Python Client API – DuckDB 13035
- 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
...Any ) ¶ Bases: Value class duckdb. CSVLineTerminator ¶ Bases: pybind11_object Members: LINE_FEED CARRIAGE_RETURN_LINE_FEED property name ¶ duckdb. CaseExpression ( condition : duckdb.duckdb.Expression , value : duckdb.duckdb.Expression ) → duckdb.duckdb....nection , width : int , scale : int ) → duckdb.duckdb.typing.DuckDBPyType ¶ Create a decimal type with ‘width' and ‘scale' property description ¶ Get result set attributes, mainly column names df ( self : duckdb.duckdb.DuckDBPyConnection , * , date_as_ob...kdb.DuckDBPyConnection , fields : object ) → duckdb.duckdb.typing.DuckDBPyType ¶ Create a struct type object from ‘fields' property rowcount ¶ Get result set row count sql ( self : duckdb.duckdb.DuckDBPyConnection , query : object , * , alias : str = ''... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Struct Data Type – DuckDB 11780
- 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
...part1 is a column One Dot SELECT part1.part2 FROM tbl ; part1 is a table, part2 is a column part1 is a column, part2 is a property of that column Two (or More) Dots SELECT part1.part2.part3 FROM tbl ; part1 is a schema, part2 is a table, part3 is a colu...mn part1 is a table, part2 is a column, part3 is a property of that column part1 is a column, part2 is a property of that column, part3 is a property of that column Any extra parts (...n columns used type Create following space single Structs values table entries DuckDB pack query expressions names structs property return 関連するページ Map Type Struct Functions CREATE TABLE Statement Star Expression INSERT Statement Friendly SQL See t... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
- Node.js API – DuckDB 9516
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...alize(sql, …params, callback) ⇒ void .stream(sql, …params) .columns() ⇒ Array.<ColumnInfo> statement.sql ⇒ Kind : instance property of Statement Returns : sql contained in statement Field : statement.get() Not implemented Kind : instance method of Statem...unk queryResult.asyncIterator() Kind : instance method of QueryResult duckdb~Database Main database interface Kind : inner property of duckdb Param Description path path to database file or :memory: for in-memory database access_mode access mode config t...et() Not implemented Kind : instance method of Database duckdb~TokenType Types of tokens return by tokenize . Kind : inner property of duckdb duckdb~ERROR : number Check that errno attribute equals this to check for a duckdb error Kind : inner constant o... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Constraints – DuckDB 9268
- 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
...nt 1' ); Constraint Error: Duplicate key "id: 1, name: Student 1" violates primary key constraint In order to enforce this property efficiently, an ART index is automatically created for every primary key or unique constraint that is defined in the table...Error: Violates foreign key constraint because key "id: 2" does not exist in the referenced table In order to enforce this property efficiently, an ART index is automatically created for every foreign key constraint that is defined in the table. Warning... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- AsOf Join – DuckDB 9020
- 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
...g this and other similar problems. One of the problems that AsOf joins are used to solve is finding the value of a varying property at a specific point in time. This use case is so common that it is where the name came from: Give me the value of the prop... - https://man.mtool.work/duckdb/1.3/guides/sql_features/asof_join.html
- Multiple Connections – DuckDB 8012
- 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
...y . All queries with the same connection label will be executed in the same connection. A test that would verify the above property would look as follows: statement ok con1 BEGIN TRANSACTION statement ok con1 CREATE TABLE integers ( i INTEGER ); statemen... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/multiple_connections.html
- Python DB API – DuckDB 7764
- 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
...on . fetchone ()) # This closes the transaction. Any subsequent calls to .fetchone will return None # None The description property of the connection object contains the column names as per the standard. Prepared Statements DuckDB also supports prepared... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- Extensions – DuckDB 7764
- 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
...sion has not been tampered with. Extension signature verification can be disabled via a configuration option. Signing is a property of the binary itself, so copying a DuckDB extension (say to serve it from a different location) will still keep a valid si... - https://man.mtool.work/duckdb/1.3/clients/wasm/extensions.html
- Java JDBC Client – DuckDB 7517
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...t to read the same database file at the same time. To open an existing database file in read-only mode, set the connection property duckdb.read_only like so: Properties readOnlyProperty = new Properties (); readOnlyProperty . setProperty ( "duckdb.read_o...nly" , "true" ); Connection conn = DriverManager . getConnection ( "jdbc:duckdb:/tmp/my_database" , readOnlyProperty ); Additional connections can be created using the DriverManager . A more efficient mechanism is to call the DuckDBConnect...d later on using PRAGMA statements as well. Properties connectionProperties = new Properties (); connectionProperties . setProperty ( "temp_directory" , "/path/to/temp/dir/" ); Connection conn = DriverManager . getConnection ( "jdbc:duckdb:/tmp/my_databa... - https://man.mtool.work/duckdb/1.3/clients/java.html
- MySQL Extension – DuckDB 7517
- 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
...operations can then be read using MySQL. Note that if modifications are not desired, ATTACH can be run with the READ_ONLY property which prevents making modifications to the underlying database. For example: ATTACH 'host=localhost user=root port=0 datab... - https://man.mtool.work/duckdb/1.3/core_extensions/mysql.html
DuckDB 1.3 Documentation / man.mtool.work