Search Result: dbExecute - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

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

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

Results of 1 - 1 of about 1 for dbExecute (0.001 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 ... sconnect(con, shutdown = TRUE) Querying DuckDB supports the standard DBI methods to send queries and 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 , "CREATE TABLE items (item VARCHAR, value DECIMAL(10, 2), count INTEGER)" ) # insert two items into the table dbExe ... ) # item value count # 1 jeans 20.0 1 # 2 hammer 42.2 2 DuckDB also supports prepared 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 ...; https://man.mtool.work/duckdb/1.3/clients/r.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work