RMySQL (version 0.2-3)

MySQL: Create a MySQL Database Connection Manager

Description

MySQLManager returns a database connection manager for MySQL. MySQL is an alias for MySQLManager.

Usage

MySQLManager(max.con=16, fetch.default.rec=5000, force.reload=F)

Arguments

max.con

number of connections to allow

fetch.default.rec

number of records to fetch by default

force.reload

logical flag to force reloading the driver. Note that this will close all currently open connections

Value

• An object of class MySQLManager inheriting from the class dbManager. It is a list with a single component Id of class dbObjectId.

References

http://www.mysql.com/

See Also

dbConnect, getDatabases

Examples

m <- MySQL()
getDatabases(m)
con <- dbConnect(m, user = "nobody", dbname = "test")
getTables(con)
close(con)