R interface to the MySQL database


[Up] [Top]

Documentation for package ‘RMySQL’ version 0.9-3

Help Pages

C D F I M P R S misc

RMySQL-package R interface to the MySQL database

-- 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-method Summarize an MySQL object
coerce-methods Summarize an MySQL object

-- D --

dbApply Apply R functions to remote groups of DBMS rows (experimental)
dbApply-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-method Call an SQL stored procedure
dbCallProc-methods Call an SQL stored procedure
dbClearResult-method Execute a statement on a given database connection
dbClearResult-methods Execute a statement on a given database connection
dbColumnInfo-method Database interface meta-data
dbColumnInfo-methods Database interface meta-data
dbCommit-method DBMS Transaction Management
dbCommit-methods DBMS Transaction Management
dbConnect-method Create a connection object to an MySQL DBMS
dbConnect-methods Create a connection object to an MySQL DBMS
dbDataType-method Determine the SQL Data Type of an S object
dbDataType-methods Determine the SQL Data Type of an S object
dbDisconnect-method Create a connection object to an MySQL DBMS
dbDisconnect-methods Create a connection object to an MySQL DBMS
dbDriver-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-method Escape a Character Vector According to SQL rules
dbEscapeStrings-methods Escape a Character Vector According to SQL rules
dbExistsTable-method Convenience functions for Importing/Exporting DBMS tables
dbExistsTable-methods Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion-methods Database interface meta-data
dbGetException-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-method Database interface meta-data
dbGetQuery-method Execute a statement on a given database connection
dbGetQuery-methods Execute a statement on a given database connection
dbGetRowCount-method Database interface meta-data
dbGetRowCount-methods Database interface meta-data
dbGetRowsAffected-method Database interface meta-data
dbGetRowsAffected-methods Database interface meta-data
dbGetStatement-method Database interface meta-data
dbGetStatement-methods Database interface meta-data
dbHasCompleted-method Database interface meta-data
dbHasCompleted-methods Database interface meta-data
dbListConnections-method List items from an MySQL DBMS and from objects
dbListConnections-methods List items from an MySQL DBMS and from objects
dbListFields-method List items from an MySQL DBMS and from objects
dbListFields-methods List items from an MySQL DBMS and from objects
dbListResults-method List items from an MySQL DBMS and from objects
dbListResults-methods List items from an MySQL DBMS and from objects
dbListTables-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-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-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-method Convenience functions for Importing/Exporting DBMS tables
dbReadTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-method Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRollback-method DBMS Transaction Management
dbRollback-methods DBMS Transaction Management
dbSendQuery-method Execute a statement on a given database connection
dbSendQuery-methods Execute a statement on a given database connection
dbSetDataMappings-method Set data mappings between MySQL and R/S-Plus
dbSetDataMappings-methods Set data mappings between MySQL and R/S-Plus
dbUnloadDriver-method MySQL implementation of the Database Interface (DBI) classes and drivers
dbUnloadDriver-methods MySQL implementation of the Database Interface (DBI) classes and drivers
dbWriteTable-method Convenience functions for Importing/Exporting DBMS tables
dbWriteTable-methods Convenience functions for Importing/Exporting DBMS tables

-- F --

fetch-method Fetch records from a previously executed query
fetch-methods Fetch records from a previously executed query
format-method Summarize an MySQL object
format-methods Summarize an MySQL object

-- I --

isIdCurrent Check whether a database handle object is valid or not
isSQLKeyword-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-method Make R/S-Plus identifiers into legal SQL identifiers
MySQL Instantiate a MySQL client from the current R session
mysqlClientLibraryVersions MySQL Check for Compiled Versus Loaded Client Library Versions
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-method Summarize an MySQL object

-- R --

RMySQL R interface to the MySQL database

-- S --

show-method Summarize an MySQL object
show-methods Summarize an MySQL object
SQLKeywords-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords-methods Make R/S-Plus identifiers into legal SQL identifiers
summary-method Summarize an MySQL object
summary-methods Summarize an MySQL object

-- misc --

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