Results of 1 - 1 of about 1 for sakila (0.001 sec.)
- SQLite Extension 9414
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...te or sqlite_scanner type. Attached SQLite databases support both read and write operations. For example, to attach to the sakila.db file , run: ATTACH 'sakila.db' (TYPE sqlite); USE sakila; The tables in the file can be read as if they were normal Duc...lm_category sales_by_store staff staff_list store You can query the tables using SQL, e.g., using the example queries from sakila-examples.sql : SELECT cat.name AS category_name, sum(ifnull(pay.amount, 0)) AS revenue FROM category cat LEFT JOIN film_ca...he SQLite database will be opened instead. For example, with the shell, a SQLite database can be opened as follows: duckdb sakila.db SELECT first_name FROM actor LIMIT 3; first_name PENELOPE NICK ED Writing Data to SQLite In addition to reading data fr... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work