db_fetch_table: Fetch a Table

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

Description

Retrieve a database table as a dataframe.

Usage

db_fetch_table(tablename, n = -1, conf_file = "~/.db_conf.yml")

Arguments

tablename	(character) A table name to query for all records.
n	(integer) The number of rows to return. (Default -1 means all rows.)
conf_file	(character) A file containing database connection parameters. (Default: "~/.db_conf.yml")

Value

(dataframe) The query result returned as a dataframe.

Details

A SQL query will return a table as a dataframe. Use 'n' to limit the number of rows returned, where n = -1 means all records.

Examples

## Not run: 
db_fetch_table("iris")

## End(Not run)

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