Database newbee problem...
Danardono wrote:
Just curious, does the function dbDriver exist in RMySQL? I usually use dbManager.
m <- dbDriver("MySQL")
con <- dbConnect(m,group="testdb")
/Danar. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
There has been a change in function names in the new RMySQL 0.5-0 version (also in the new ROracle and RSQLite). The reason is that the R-SIG-DB has agreed on a common interface to all databases, and as part of this new common interface, most functions have been renamed. The following simple name mapping may help you upgrade existing code to the new DBI: pre-DBI DBI 0.1-4 ---------------------- ---------------------------------- dbManager dbDriver dbConnect dbConnect dbExecStatement dbSendQuery dbExec dbSendQuery quickSQL dbGetQuery fetch fetch getTables dbListTables getConnections dbListConnections getResultSets dbListResults getConnection dbGetConnection getFields dbColumnInfo # for a result set getFields dbListFields # for a table name in a conn getStatement dbGetStatement getRowsAffected dbGetRowsAffected getRowCount dbGetRowCount hasCompleted dbHasCompleted getInfo dbGetInfo describe summary getTableFields dbListFields getTable dbReadTable assignTable dbWriteTable existsTable dbExistsTable SQLDataType dbDataType make.SQL.name make.db.name isSQLKeyword isSQLKeyword removeTable dbRemoveTable getException dbGetException load dbDriver unload dbUnloadDriver commit dbCommit rollback dbRollback callProc dbCallProc close dbDisconnect close dbClearResult getVersion NA getCurrentDatabase NA getNumRows NA getNullOk NA getNumCols NA getDatabases NA getTableIndices NA NA dbGetDBIVersion
David A. James Statistics Research, Room 2C-253 Phone: (908) 582-3082 Bell Labs, Lucent Technologies Fax: (908) 582-3340 Murray Hill, NJ 09794-0636 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._