Skip to contents

Database interface meta-data.

Source: R/dbColumnInfo_MariaDBResult.R, R/dbGetRowCount_MariaDBResult.R, R/dbGetRowsAffected_MariaDBResult.R, and 2 more
result-meta.Rd

See documentation of generics for more details.

Usage

# S4 method for MariaDBResult
dbColumnInfo(res, ...)

# S4 method for MariaDBResult
dbGetRowCount(res, ...)

# S4 method for MariaDBResult
dbGetRowsAffected(res, ...)

# S4 method for MariaDBResult
dbHasCompleted(res, ...)

Arguments

res

An object of class MariaDBResult

...

Ignored. Needed for compatibility with generic

Examples

if (mariadbHasDefault()) {
  con <- dbConnect(RMariaDB::MariaDB(), dbname = "test")
  dbWriteTable(con, "t1", datasets::USArrests, temporary = TRUE)

  rs <- dbSendQuery(con, "SELECT * FROM t1 WHERE UrbanPop >= 80")
  rs

  dbGetStatement(rs)
  dbHasCompleted(rs)
  dbColumnInfo(rs)

  dbFetch(rs)
  rs

  dbClearResult(rs)
  dbDisconnect(con)
}