SELECT: Apply a select query to the UWIN database.

View source: R/database_functions.R

SELECTR Documentation

Apply a select query to the UWIN database.

Description

SELECT will send select SQL queries to the UWIN database and return the output.

Usage

SELECT(sql = NULL, db = uwidb)

Arguments

sql

A SQL statement input as a character vector to be sent to the UWIN database.

db

The MySQL connection to the UWIN database. Defaults to 'uwidb'

Value

A data.frame with the output from the SQL statement.

Examples

## Not run: 
my_sql <- 'SELECT * FROM Visits;'
SELECT(my_sql)

## End(Not run)

mfidino/uwinutils documentation built on June 11, 2025, 1:49 p.m.