# R interface to the MySQL database

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