Package index

All functions

MySQL()

Class MySQLDriver with constructor MySQL.

constants .MySQLPkgName .MySQLPkgVersion .MySQLPkgRCS .MySQLSQLKeywords CLIENT_LONG_PASSWORD CLIENT_FOUND_ROWS CLIENT_LONG_FLAG CLIENT_CONNECT_WITH_DB CLIENT_NO_SCHEMA CLIENT_COMPRESS CLIENT_ODBC CLIENT_LOCAL_FILES CLIENT_IGNORE_SPACE CLIENT_PROTOCOL_41 CLIENT_INTERACTIVE CLIENT_SSL CLIENT_IGNORE_SIGPIPE CLIENT_TRANSACTIONS CLIENT_RESERVED CLIENT_SECURE_CONNECTION CLIENT_MULTI_STATEMENTS CLIENT_MULTI_RESULTS

Constants

dbGetInfo(<MySQLConnection>) dbListResults(<MySQLConnection>) summary(<MySQLConnection>) dbGetException(<MySQLConnection>) show(<MySQLConnection>)

Database interface meta-data

dbApply()

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)

dbConnect(<MySQLDriver>) dbConnect(<MySQLConnection>) dbDisconnect(<MySQLConnection>)

Connect/disconnect to a MySQL DBMS

dbDataType(<MySQLDriver>) dbDataType(<MySQLConnection>)

Determine the SQL Data Type of an S object

dbEscapeStrings()

Escape SQL-special characters in strings.

dbGetInfo(<MySQLDriver>) dbListConnections(<MySQLDriver>) summary(<MySQLDriver>) show(<MySQLDriver>)

Get information about a MySQL driver.

dbNextResult() dbMoreResults()

Fetch next result set from an SQL script or stored procedure (experimental)

dbReadTable(<MySQLConnection>,<character>) dbListTables(<MySQLConnection>) dbExistsTable(<MySQLConnection>,<character>) dbRemoveTable(<MySQLConnection>,<character>) dbListFields(<MySQLConnection>,<character>)

Convenience functions for importing/exporting DBMS tables

dbUnloadDriver(<MySQLDriver>)

Unload MySQL driver.

dbWriteTable(<MySQLConnection>,<character>,<data.frame>) dbWriteTable(<MySQLConnection>,<character>,<character>)

Write a local data frame or file to the database.

isIdCurrent() dbIsValid(<MySQLDriver>) dbIsValid(<MySQLConnection>) dbIsValid(<MySQLResult>)

Check if a database object is valid.

make.db.names(<MySQLConnection>,<character>) SQLKeywords(<MySQLConnection>) isSQLKeyword(<MySQLConnection>,<character>)

Make R/S-Plus identifiers into legal SQL identifiers

mysqlClientLibraryVersions()

MySQL Check for Compiled Versus Loaded Client Library Versions

mysqlHasDefault()

Check if default database is available.

dbFetch(<MySQLResult>,<numeric>) fetch(<MySQLResult>,<numeric>) dbFetch(<MySQLResult>,<missing>) fetch(<MySQLResult>,<missing>) dbSendQuery(<MySQLConnection>,<character>) dbClearResult(<MySQLResult>) dbGetInfo(<MySQLResult>) dbGetStatement(<MySQLResult>) dbListFields(<MySQLResult>,<missing>)

Execute a SQL statement on a database connection.

dbColumnInfo(<MySQLResult>) dbGetRowsAffected(<MySQLResult>) dbGetRowCount(<MySQLResult>) dbHasCompleted(<MySQLResult>) dbGetException(<MySQLResult>) summary(<MySQLResult>) show(<MySQLResult>)

Database interface meta-data.

dbCommit(<MySQLConnection>) dbBegin(<MySQLConnection>) dbRollback(<MySQLConnection>)

DBMS Transaction Management