Package: RMySQL 0.10.29

Jeroen Ooms

RMySQL: Database Interface and 'MySQL' Driver for R

Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code ported from S-PLUS. A modern 'MySQL' client written in 'C++' is available from the 'RMariaDB' package.

Authors:Jeroen Ooms [aut, cre], David James [aut], Saikat DebRoy [aut], Hadley Wickham [aut], Jeffrey Horner [aut], RStudio [cph]

RMySQL_0.10.29.tar.gz
RMySQL_0.10.29.tar.gz(r-4.5-noble)RMySQL_0.10.29.tar.gz(r-4.4-noble)
RMySQL.pdf |RMySQL.html
RMySQL/json (API)
NEWS

# Install 'RMySQL' in R:
install.packages('RMySQL', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/r-dbi/rmysql/issues

Uses libs:
  • mysql– MySQL database client library

9.29 score 3 stars 13 packages 4.0k scripts 69k downloads 24 mentions 60 exports 1 dependencies

Last updated 2 months agofrom:ff8fc386e9. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKNov 04 2024
R-4.5-linux-x86_64OKNov 04 2024

Exports:CLIENT_COMPRESSCLIENT_CONNECT_WITH_DBCLIENT_FOUND_ROWSCLIENT_IGNORE_SIGPIPECLIENT_IGNORE_SPACECLIENT_INTERACTIVECLIENT_LOCAL_FILESCLIENT_LONG_FLAGCLIENT_LONG_PASSWORDCLIENT_MULTI_RESULTSCLIENT_MULTI_STATEMENTSCLIENT_NO_SCHEMACLIENT_ODBCCLIENT_PROTOCOL_41CLIENT_RESERVEDCLIENT_SECURE_CONNECTIONCLIENT_SSLCLIENT_TRANSACTIONSdbApplydbBegindbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbEscapeStringsdbExistsTabledbFetchdbGetExceptiondbGetInfodbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListConnectionsdbListFieldsdbListResultsdbListTablesdbMoreResultsdbNextResultdbQuoteIdentifierdbReadTabledbRemoveTabledbRollbackdbSendQuerydbUnloadDriverdbWriteTablefetchisIdCurrentisSQLKeywordmake.db.namesMySQLmysqlBuildTableDefinitionmysqlClientLibraryVersionsmysqlHasDefaultshowSQLKeywordssummary

Dependencies:DBI

Readme and manuals

Help Manual

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