db_fetch_query: Fetch Results from a Query

In deohs/RMariaDBHelper: Helper functions to make RMariaDB easier to use

Description

Run a database query that returns a dataframe.

Usage

db_fetch_query(query, conf_file = "~/.db_conf.yml", ...)

Arguments

query	(character) A SQL statement as a text string.
conf_file	(character) A file containing database connection parameters. (Default: "~/.db_conf.yml")
...	Additional arguments passed to RMariaDB::dbGetQuery().

Value

(dataframe) The query result returned as a dataframe.

Details

A SQL statement will be run and a dataframe of results will be returned.

Examples

## Not run: 
db_fetch_query("SELECT * FROM my.tablename LIMIT 10;")

## End(Not run)

deohs/RMariaDBHelper documentation built on Dec. 31, 2020, 11:17 p.m.