dbGetInfo-methods {RMySQL}R Documentation

Database interface meta-data

Description

These methods are straight-forward implementations of the corresponding generic functions.

Methods

dbObj
any object that implements some functionality in the R/S-Plus interface to databases (a driver, a connection or a result set).
res
an MySQLResult.
...
currently not being used.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

MySQL, dbDriver, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbListTables, dbReadTable.

Examples

## Not run: 
drv <- dbDriver("MySQL")
con <- dbConnect(drv, group = "wireless")

dbListTables(con)

rs <- dbSendQuery(con, query.sql)
dbGetStatement(rs)
dbHasCompleted(rs)

info <- dbGetInfo(rs)
names(dbGetInfo(drv))  

# DBIConnection info
names(dbGetInfo(con))

# DBIResult info
names(dbGetInfo(rs)) 
## End(Not run)

[Package RMySQL version 0.6-0 Index]