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