Execute SELECT query — select • dabr

Execute SELECT query

select(conn, ...)

# S3 method for 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

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