R interface to the MySQL database


[Package List] [Top]

Documentation for package ‘RMySQL’ version 0.6-0

User Guides and Package Vignettes

Read overview or browse directory.

Help Pages

C D F I M P R S

-- --

RMySQL-package R interface to the MySQL database

-- --

.conflicts.OK Support Functions
.MySQL.NA.string Support Functions
.MySQLPkgName Support Functions
.MySQLPkgRCS Support Functions
.MySQLPkgVersion Support Functions
.MySQLSQLKeywords Support Functions

-- C --

CLIENT_COMPRESS Support Functions
CLIENT_CONNECT_WITH_DB Support Functions
CLIENT_FOUND_ROWS Support Functions
CLIENT_IGNORE_SIGPIPE Support Functions
CLIENT_IGNORE_SPACE Support Functions
CLIENT_INTERACTIVE Support Functions
CLIENT_LOCAL_FILES Support Functions
CLIENT_LONG_FLAG Support Functions
CLIENT_LONG_PASSWORD Support Functions
CLIENT_MULTI_RESULTS Support Functions
CLIENT_MULTI_STATEMENTS Support Functions
CLIENT_NO_SCHEMA Support Functions
CLIENT_ODBC Support Functions
CLIENT_PROTOCOL_41 Support Functions
CLIENT_RESERVED Support Functions
CLIENT_SECURE_CONNECTION Support Functions
CLIENT_SSL Support Functions
CLIENT_TRANSACTIONS Support Functions
coerce,dbObjectId,character-method Summarize an MySQL object
coerce,dbObjectId,integer-method Summarize an MySQL object
coerce,dbObjectId,numeric-method Summarize an MySQL object
coerce,MySQLConnection,MySQLDriver-method Summarize an MySQL object
coerce,MySQLConnection,MySQLResult-method Summarize an MySQL object
coerce,MySQLObject,MySQLDriver-method Summarize an MySQL object
coerce,MySQLResult,MySQLConnection-method Summarize an MySQL object
coerce,MySQLResult,MySQLDriver-method Summarize an MySQL object
coerce-methods Summarize an MySQL object

-- D --

dbApply Apply R functions to remote groups of DBMS rows (experimental)
dbApply,MySQLResult-method Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbApply-methods Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbBuildTableDefinition Build the SQL CREATE TABLE definition as a string
dbCallProc,MySQLConnection-method Call an SQL stored procedure
dbCallProc-methods Call an SQL stored procedure
dbClearResult,MySQLResult-method Execute a statement on a given database connection
dbClearResult-methods Execute a statement on a given database connection
dbColumnInfo,MySQLResult-method Database interface meta-data
dbColumnInfo-methods Database interface meta-data
dbCommit,MySQLConnection-method DBMS Transaction Management
dbCommit-methods DBMS Transaction Management
dbConnect,character-method Create a connection object to an MySQL DBMS
dbConnect,MySQLConnection-method Create a connection object to an MySQL DBMS
dbConnect,MySQLDriver-method Create a connection object to an MySQL DBMS
dbConnect-methods Create a connection object to an MySQL DBMS
dbDataType,MySQLObject-method Determine the SQL Data Type of an S object
dbDataType-methods Determine the SQL Data Type of an S object
dbDisconnect,MySQLConnection-method Create a connection object to an MySQL DBMS
dbDisconnect-methods Create a connection object to an MySQL DBMS
dbDriver,character-method MySQL implementation of the Database Interface (DBI) classes and drivers
dbDriver-methods MySQL implementation of the Database Interface (DBI) classes and drivers
dbEscapeStrings Escape SQL-special characters in strings
dbEscapeStrings,MySQLConnection,character-method Escape a Character Vector According to SQL rules
dbEscapeStrings,MySQLResult,character-method Escape a Character Vector According to SQL rules
dbEscapeStrings-methods Escape a Character Vector According to SQL rules
dbExistsTable,MySQLConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbExistsTable-methods Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion-methods Database interface meta-data
dbGetException,MySQLConnection-method Execute a statement on a given database connection
dbGetException,MySQLResult-method Execute a statement on a given database connection
dbGetException-methods Execute a statement on a given database connection
dbGetInfo Database interface meta-data
dbGetInfo,MySQLConnection-method Database interface meta-data
dbGetInfo,MySQLDriver-method Database interface meta-data
dbGetInfo,MySQLObject-method Database interface meta-data
dbGetInfo,MySQLResult-method Database interface meta-data
dbGetQuery,MySQLConnection,character-method Execute a statement on a given database connection
dbGetQuery-methods Execute a statement on a given database connection
dbGetRowCount,MySQLResult-method Database interface meta-data
dbGetRowCount-methods Database interface meta-data
dbGetRowsAffected,MySQLResult-method Database interface meta-data
dbGetRowsAffected-methods Database interface meta-data
dbGetStatement,MySQLResult-method Database interface meta-data
dbGetStatement-methods Database interface meta-data
dbHasCompleted,MySQLResult-method Database interface meta-data
dbHasCompleted-methods Database interface meta-data
dbListConnections,MySQLDriver-method List items from an MySQL DBMS and from objects
dbListConnections-methods List items from an MySQL DBMS and from objects
dbListFields,MySQLConnection,character-method List items from an MySQL DBMS and from objects
dbListFields,MySQLResult,missing-method List items from an MySQL DBMS and from objects
dbListFields-methods List items from an MySQL DBMS and from objects
dbListResults,MySQLConnection-method List items from an MySQL DBMS and from objects
dbListResults-methods List items from an MySQL DBMS and from objects
dbListTables,MySQLConnection-method List items from an MySQL DBMS and from objects
dbListTables-methods List items from an MySQL DBMS and from objects
dbMoreResults Fetch next result set from an SQL script or stored procedure (experimental)
dbMoreResults,MySQLConnection-method Fetch Next Result Set from Multiple Statements or Stored Procedures
dbMoreResults-methods Fetch Next Result Set from Multiple Statements or Stored Procedures
dbNextResult Fetch next result set from an SQL script or stored procedure (experimental)
dbNextResult,MySQLConnection-method Fetch Next Result Set from Multiple Statements or Stored Procedures
dbNextResult-methods Fetch Next Result Set from Multiple Statements or Stored Procedures
dbObjectId-class Class dbObjectId
dbReadTable,MySQLConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbReadTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable,MySQLConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRollback,MySQLConnection-method DBMS Transaction Management
dbRollback-methods DBMS Transaction Management
dbSendQuery,MySQLConnection,character-method Execute a statement on a given database connection
dbSendQuery-methods Execute a statement on a given database connection
dbSetDataMappings,MySQLResult,data.frame-method Set data mappings between MySQL and R/S-Plus
dbSetDataMappings-methods Set data mappings between MySQL and R/S-Plus
dbUnloadDriver,MySQLDriver-method MySQL implementation of the Database Interface (DBI) classes and drivers
dbUnloadDriver-methods MySQL implementation of the Database Interface (DBI) classes and drivers
dbWriteTable,MySQLConnection,character,character-method Convenience functions for Importing/Exporting DBMS tables
dbWriteTable,MySQLConnection,character,data.frame-method Convenience functions for Importing/Exporting DBMS tables
dbWriteTable-methods Convenience functions for Importing/Exporting DBMS tables

-- F --

fetch,MySQLResult,missing-method Fetch records from a previously executed query
fetch,MySQLResult,numeric-method Fetch records from a previously executed query
fetch-methods Fetch records from a previously executed query
format,dbObjectId-method Summarize an MySQL object
format-methods Summarize an MySQL object

-- I --

isIdCurrent Check whether a database handle object is valid or not
isSQLKeyword,MySQLObject,character-method Make R/S-Plus identifiers into legal SQL identifiers
isSQLKeyword-methods Make R/S-Plus identifiers into legal SQL identifiers

-- M --

make.db.names,MySQLObject,character-method Make R/S-Plus identifiers into legal SQL identifiers
MySQL Instantiate a MySQL client from the current R session
mysqlCloneConnection Support Functions
mysqlCloseConnection Support Functions
mysqlCloseDriver Support Functions
mysqlCloseResult Support Functions
MySQLConnection-class Class MySQLConnection
mysqlConnectionInfo Support Functions
mysqlDataType Support Functions
mysqlDBApply Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
mysqlDescribeConnection Support Functions
mysqlDescribeDriver Support Functions
mysqlDescribeFields Support Functions
mysqlDescribeResult Support Functions
MySQLDriver-class Class MySQLDriver
mysqlDriverInfo Support Functions
mysqlEscapeStrings Support Functions
mysqlExecStatement Support Functions
mysqlFetch Support Functions
mysqlImportFile Support Functions
mysqlInitDriver Support Functions
mysqlNewConnection Support Functions
MySQLObject-class Class MySQLObject
mysqlQuickSQL Support Functions
mysqlReadTable Support Functions
MySQLResult-class Class MySQLResult
mysqlResultInfo Support Functions
mysqlWriteTable Support Functions

-- P --

print,dbObjectId-method Summarize an MySQL object

-- R --

RMySQL R interface to the MySQL database

-- S --

show,dbObjectId-method Summarize an MySQL object
show-methods Summarize an MySQL object
SQLKeywords,missing-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords,MySQLObject-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords-methods Make R/S-Plus identifiers into legal SQL identifiers
summary,MySQLConnection-method Summarize an MySQL object
summary,MySQLDriver-method Summarize an MySQL object
summary,MySQLObject-method Summarize an MySQL object
summary,MySQLResult-method Summarize an MySQL object
summary-methods Summarize an MySQL object