select: Execute 'SELECT' query

In special-uor/dabr: Database Management with R

Execute SELECT query

Description

Execute SELECT query

Usage

select(conn, ...)

## S3 method for class 'MariaDBConnection'
select(conn, ..., quiet = FALSE)

Arguments

conn	DB connection object.
...	SELECT query and optional parameters.
quiet	Boolean flag to hide status messages.

Value

Data frame containing the selected records.

See Also

Other DB functions: close_conn(), delete(), insert(), list_tables(), open_conn_mysql(), select_all(), update()

Examples

## Not run: 
conn <- open_conn_mysql("sys", "root")
out <- select(conn, "SELECT variable, value FROM sys_config")
close_conn(conn)

## End(Not run)

special-uor/dabr documentation built on Oct. 21, 2022, 3:04 p.m.