Package: RMySQL 0.10.29
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.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')) |
Bug tracker:https://github.com/r-dbi/rmysql/issues
Last updated 2 months agofrom:ff8fc386e9. Checks:OK: 2. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Dec 04 2024 |
R-4.5-linux-x86_64 | OK | Dec 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 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 |