[R] Database newbee problem...
David James
dj at research.bell-labs.com
Thu Oct 17 15:40:48 CEST 2002
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
More information about the R-help
mailing list