Search Result: getvariable - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 1 of about 1 for getvariable (0.005 sec.)

SET VARIABLE and RESET VARIABLE Statements – DuckDB 9414: 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 ... a Global Variable . SET VARIABLE The SET VARIABLE statement assigns a value to a variable, which can be accessed using the getvariable call: SET VARIABLE my_var = 30 ; SELECT 20 + getvariable ( 'my_var' ) AS total ; total 50 If SET VARIABLE is invoked on an ... existing variable, it will overwrite its value: SET VARIABLE my_var = 30 ; SET VARIABLE my_var = 100 ; SELECT 20 + getvariable ( 'my_var' ) AS total ; total 120 Variables can have different types: SET VARIABLE my_date = DATE '2018-07-13' ; SET VARIA ... files SET VARIABLE list_of_files = ( SELECT list ( file ) FROM csv_files ); -- read the CSV files SELECT * FROM read_csv ( getvariable ( 'list_of_files' ), filename : = True ); a filename 42 test.csv 84 test2.csv If a variable is not set, the getvariable fu ...; https://man.mtool.work/duckdb/1.3/sql/statements/set_variable.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work