# Database Interface and 'MySQL' Driver for R

## Documentation for package ‘RMySQL’ version 0.10.23

- DESCRIPTION file.

## Help Pages

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