runmysql: runmysql Function

Description Usage Arguments Examples

Description

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.

Usage

1
2
runmysql(statement, con = NULL, user = NULL, password = NULL,
  host = NULL, dbname = NULL)

Arguments

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.

Examples

1
runmysql(statement = "select * from tbl_main")

KonoAnalytics/KonostdlibR documentation built on May 8, 2019, 5:47 p.m.