Description Usage Arguments Details Value Examples
View source: R/HelperFunctions.R
This function sends SQL to the server, and returns the results.
1 | querySql(connection, sql)
|
connection |
The connection to the database server. |
sql |
The SQL to be send. |
This function sends the SQL to the server and retrieves the results. If an error occurs during SQL execution, this error is written to a file to facilitate debugging.
A data frame.
1 2 3 4 5 6 7 8 9 10 11 | ## Not run:
connectionDetails <- createConnectionDetails(dbms = "mysql",
server = "localhost",
user = "root",
password = "blah",
schema = "cdm_v4")
conn <- connect(connectionDetails)
count <- querySql(conn, "SELECT COUNT(*) FROM person")
dbDisconnect(conn)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.