db.query.Rd
Generic function to query database
db.query(query, con = NULL, params = NULL)
query | SQL query string |
---|---|
con | database connection object |
params | database connection information |
data frame with query results
Given a connection and a query, will return a query as a data frame. Either con or params need to be specified. If both are specified it will use con.
# NOT RUN { db.query('select count(id) from traits;', params=settings$database$bety) # }