# R interface to the MySQL database

## Documentation for package ‘RMySQL’ version 0.9-3

- DESCRIPTION file.
- User guides, package vignettes and other documentation.
- Package NEWS.

## 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