|
MySQL()
|
Class MySQLDriver with constructor MySQL. |
|
constants .MySQLPkgName .MySQLPkgVersion .MySQLPkgRCS .MySQLSQLKeywords CLIENT_LONG_PASSWORD CLIENT_FOUND_ROWS CLIENT_LONG_FLAG CLIENT_CONNECT_WITH_DB CLIENT_NO_SCHEMA CLIENT_COMPRESS CLIENT_ODBC CLIENT_LOCAL_FILES CLIENT_IGNORE_SPACE CLIENT_PROTOCOL_41 CLIENT_INTERACTIVE CLIENT_SSL CLIENT_IGNORE_SIGPIPE CLIENT_TRANSACTIONS CLIENT_RESERVED CLIENT_SECURE_CONNECTION CLIENT_MULTI_STATEMENTS CLIENT_MULTI_RESULTS
|
Constants |
|
dbGetInfo(<MySQLConnection>) dbListResults(<MySQLConnection>) summary(<MySQLConnection>) dbGetException(<MySQLConnection>) show(<MySQLConnection>)
|
Database interface meta-data |
|
dbApply()
|
Apply R/S-Plus functions to remote groups of DBMS rows (experimental) |
|
dbConnect(<MySQLDriver>) dbConnect(<MySQLConnection>) dbDisconnect(<MySQLConnection>)
|
Connect/disconnect to a MySQL DBMS |
|
dbDataType(<MySQLDriver>) dbDataType(<MySQLConnection>)
|
Determine the SQL Data Type of an S object |
|
dbEscapeStrings()
|
Escape SQL-special characters in strings. |
|
dbGetInfo(<MySQLDriver>) dbListConnections(<MySQLDriver>) summary(<MySQLDriver>) show(<MySQLDriver>)
|
Get information about a MySQL driver. |
|
dbNextResult() dbMoreResults()
|
Fetch next result set from an SQL script or stored procedure (experimental) |
|
dbReadTable(<MySQLConnection>,<character>) dbListTables(<MySQLConnection>) dbExistsTable(<MySQLConnection>,<character>) dbRemoveTable(<MySQLConnection>,<character>) dbListFields(<MySQLConnection>,<character>)
|
Convenience functions for importing/exporting DBMS tables |
|
dbUnloadDriver(<MySQLDriver>)
|
Unload MySQL driver. |
|
dbWriteTable(<MySQLConnection>,<character>,<data.frame>) dbWriteTable(<MySQLConnection>,<character>,<character>)
|
Write a local data frame or file to the database. |
|
isIdCurrent() dbIsValid(<MySQLDriver>) dbIsValid(<MySQLConnection>) dbIsValid(<MySQLResult>)
|
Check if a database object is valid. |
|
make.db.names(<MySQLConnection>,<character>) SQLKeywords(<MySQLConnection>) isSQLKeyword(<MySQLConnection>,<character>)
|
Make R/S-Plus identifiers into legal SQL identifiers |
|
mysqlClientLibraryVersions()
|
MySQL Check for Compiled Versus Loaded Client Library Versions |
|
mysqlHasDefault()
|
Check if default database is available. |
|
dbFetch(<MySQLResult>,<numeric>) fetch(<MySQLResult>,<numeric>) dbFetch(<MySQLResult>,<missing>) fetch(<MySQLResult>,<missing>) dbSendQuery(<MySQLConnection>,<character>) dbClearResult(<MySQLResult>) dbGetInfo(<MySQLResult>) dbGetStatement(<MySQLResult>) dbListFields(<MySQLResult>,<missing>)
|
Execute a SQL statement on a database connection. |
|
dbColumnInfo(<MySQLResult>) dbGetRowsAffected(<MySQLResult>) dbGetRowCount(<MySQLResult>) dbHasCompleted(<MySQLResult>) dbGetException(<MySQLResult>) summary(<MySQLResult>) show(<MySQLResult>)
|
Database interface meta-data. |
|
dbCommit(<MySQLConnection>) dbBegin(<MySQLConnection>) dbRollback(<MySQLConnection>)
|
DBMS Transaction Management |