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:
RMySQL_0.10.29.tar.gz
RMySQL_0.10.29.zip(r-4.5)RMySQL_0.10.29.zip(r-4.4)RMySQL_0.10.29.zip(r-4.3)
RMySQL_0.10.29.tgz(r-4.4-x86_64)RMySQL_0.10.29.tgz(r-4.4-arm64)RMySQL_0.10.29.tgz(r-4.3-x86_64)RMySQL_0.10.29.tgz(r-4.3-arm64)
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://r-dbi.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/r-dbi/rmysql/issues
Last updated 1 months agofrom:0846eddb52. Checks:OK: 9. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Nov 02 2024 |
| R-4.5-win-x86_64 | OK | Nov 02 2024 |
| R-4.5-linux-x86_64 | OK | Nov 02 2024 |
| R-4.4-win-x86_64 | OK | Nov 02 2024 |
| R-4.4-mac-x86_64 | OK | Nov 02 2024 |
| R-4.4-mac-aarch64 | OK | Nov 02 2024 |
| R-4.3-win-x86_64 | OK | Nov 02 2024 |
| R-4.3-mac-x86_64 | OK | Nov 02 2024 |
| R-4.3-mac-aarch64 | OK | Nov 02 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 page | Topics |
|---|---|
| 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-data | db-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 DBMS | dbConnect,MySQLConnection-method dbConnect,MySQLDriver-method dbDisconnect,MySQLConnection-method |
| Determine the SQL Data Type of an S object | dbDataType,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 tables | dbExistsTable,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 identifiers | isSQLKeyword,MySQLConnection,character-method make.db.names,MySQLConnection,character-method SQLKeywords,MySQLConnection-method |
| MySQL Check for Compiled Versus Loaded Client Library Versions | mysqlClientLibraryVersions |
| 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 Management | dbBegin,MySQLConnection-method dbCommit,MySQLConnection-method dbRollback,MySQLConnection-method transactions |
