dabr (version 0.0.4)

select: Execute SELECT query

Description

Execute SELECT query

Usage

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

Value

Data frame containing the selected records.

Arguments

conn

DB connection object.

...

SELECT query and optional parameters.

quiet

Boolean flag to hide status messages.

See Also

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

Examples

if (FALSE) {
conn <- open_conn_mysql("sys", "root")
out <- select(conn, "SELECT variable, value FROM sys_config")
close_conn(conn)
}