krsp_sql: Run SQL query on database
In mstrimas/krsp: Working with the Kluane Red Squirrel Project Database
Description
Usage
Arguments
Value
Examples
Description
Run a pure SQL query on the KRSP database and return a data frame. To avoid
accidentally changing the database, only SELECT queries are permitted.
Usage
1
krsp_sql(con, sql)
Arguments
con
Connection to KRSP database
sql
SQL query to execute
Value
data.frame of query results
Examples
1
2
con <- krsp_connect()
krsp_sql(con, "SELECT COUNT(*) AS n_squirrels FROM squirrel")
mstrimas/krsp documentation built on May 23, 2019, 8:16 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value Examples
Description
Run a pure SQL query on the KRSP database and return a data frame. To avoid
accidentally changing the database, only SELECT queries are permitted.
Usage
1 | krsp_sql(con, sql)
|
Arguments
con |
Connection to KRSP database |
sql |
SQL query to execute |
Value
data.frame of query results
Examples
1 2 | con <- krsp_connect()
krsp_sql(con, "SELECT COUNT(*) AS n_squirrels FROM squirrel")
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.