MySQLResult-class {RMySQL} | R Documentation

## Class MySQLResult

### Description

MySQL's query results class. This classes encapsulates the result of an SQL statement (either `select` or not).

### Generators

The main generator is `dbSendQuery`.

### Extends

Class `"DBIResult"`, directly. Class `"MySQLObject"`, directly. Class `"DBIObject"`, by class "DBIResult". Class `"dbObjectId"`, by class "MySQLObject".

### Methods

coerce
  `signature(from = "MySQLConnection", to = "MySQLResult")`: ...
dbClearResult
  `signature(res = "MySQLResult")`: ...
dbColumnInfo
  `signature(res = "MySQLResult")`: ...
dbGetException
  `signature(conn = "MySQLResult")`: ...
dbGetInfo
  `signature(dbObj = "MySQLResult")`: ...
dbGetRowCount
  `signature(res = "MySQLResult")`: ...
dbGetRowsAffected
  `signature(res = "MySQLResult")`: ...
dbGetStatement
  `signature(res = "MySQLResult")`: ...
dbHasCompleted
  `signature(res = "MySQLResult")`: ...
dbListFields
  `signature(conn = "MySQLResult", name = "missing")`: ...
fetch
  `signature(res = "MySQLResult", n = "numeric")`: ...
fetch
  `signature(res = "MySQLResult", n = "missing")`: ...
summary
  `signature(object = "MySQLResult")`: ...

### References

See the Database Interface definition document `DBI.pdf` in the base directory of this package or http://developer.r-project.org/db.

### See Also

DBI base classes:

`DBIObject-class` `DBIDriver-class` `DBIConnection-class` `DBIResult-class`

MySQL classes:

`MySQLObject-class` `MySQLDriver-class` `MySQLConnection-class` `MySQLResult-class`

### Examples

    ## Not run:
    drv <- dbDriver("MySQL")
    con <- dbConnect(drv, dbname = "rsdbi.db")
    ## End(Not run)

[Package RMySQL version 0.6-0 Index]