db_str: Show structure of a table.

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

Description

Run a database query on a table that shows the columns and their properties.

Usage

db_str(tablename, conf_file = "~/.db_conf.yml")

Arguments

tablename	(character) A table name to query for structure.
conf_file	(character) A file containing database connection parameters. (Default: "~/.db_conf.yml")

Value

(dataframe) The query result returned as a dataframe.

Details

A SHOW COLUMNS query will return a dataframe of columns and their properties.

Examples

## Not run: 
db_str("iris")

## End(Not run)

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