db_run_query: Run a Query

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

Description

Run a database query that returns the number of affected rows.

Usage

db_run_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::dbExecute().

Value

(integer) The number of affected rows.

Details

A SQL statement will be run and the number of affected rows will be returned.

Examples

## Not run: 
db_run_query("DELETE FROM my.tablename WHERE id = 1;")

## End(Not run)

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