db_getColumn | R Documentation |
gets specified columns from a table in the database, allows for where statements
db_getColumn(db, tableName, column = NA, where = NA)
db |
database access 'handle' |
tableName |
name of the table |
column |
if NA then all columns are retrieved, otherwise should be a character vector specifying the names of the columns to be retrieved |
where |
allows for conditional retrieving, should be in the form of a character vector specifying the conditions and boolean operators, eg: c("age = 45", " AND ", "gender = 'M') |
data.frame
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.