Description Usage Arguments Examples
This function allows you to execute a mysql statement against a mysql database. The only required parameter is the mysql statement. All others may be NULL. The function returns a dataframe.
1 2 |
statement |
The MYSQL statement you would like to execute. |
con |
A connection of type MySQLConnection as described in theRMySQL package. If NULL, one will be created. |
user |
The user id of the database. |
password |
The password of the dataase. |
host |
Where the database resides. |
dbname |
The name of the database. |
1 | runmysql(statement = "select * from tbl_main")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.