Description Usage Arguments Examples
Select records
1 |
conn |
A DBIConnection object |
statement |
The SQL statement to use |
params |
Parameters to bind |
1 2 3 4 5 6 7 8 | db <- dbxConnect(adapter="sqlite", dbname=":memory:")
DBI::dbCreateTable(db, "forecasts", data.frame(id=1:3, temperature=20:22))
dbxSelect(db, "SELECT * FROM forecasts")
dbxSelect(db, "SELECT * FROM forecasts WHERE id = ?", params=list(1))
dbxSelect(db, "SELECT * FROM forecasts WHERE id IN (?)", params=list(1:3))
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.