Search Result: dbGetQuery - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

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

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

Results of 1 - 1 of about 1 for dbGetQuery (0.003 sec.)

R Client – 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 ... retrieve result sets. dbExecute() is meant for queries where no results are expected like CREATE TABLE or UPDATE etc. and dbGetQuery() is meant to be used for queries that produce results (e.g., SELECT ). Below an example. # create a table dbExecute ( con ... e dbExecute ( con , "INSERT INTO items VALUES ('jeans', 20.0, 1), ('hammer', 42.2, 2)" ) # retrieve the items again res <- dbGetQuery ( con , "SELECT * FROM items" ) print ( res ) # item value count # 1 jeans 20.0 1 # 2 hammer 42.2 2 DuckDB also supports p ... repared statements in the R client with the dbExecute and dbGetQuery methods. Here is an example: # prepared statement parameters are given as a list dbExecute ( con , "INSERT INTO items VALU ...; https://man.mtool.work/duckdb/1.3/clients/r.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work