RMySQL: Database Interface and 'MySQL' Driver for R
R上でMySQLデータベースを操作する
- CRAN: http://cran.r-project.org/web/packages/RMySQL/index.html
- GitHub: https://github.com/rstats-db/rmysql
- URL: https://downloads.mariadb.org/connector-c/
> library(RMySQL)
Error: package or namespace load failed for 'RMySQL'
バージョン: 0.10.5
関数名 | 概略 |
---|---|
MySQLDriver-class |
Class MySQLDriver with constructor MySQL. |
constants |
Constants |
db-meta |
Database interface meta-data |
dbApply |
Apply R/S-Plus functions to remote groups of DBMS rows (experimental) |
dbConnect,MySQLDriver-method |
Connect/disconnect to a MySQL DBMS |
dbDataType,MySQLDriver-method |
Determine the SQL Data Type of an S object |
dbEscapeStrings |
Escape SQL-special characters in strings. |
dbFetch,MySQLResult,numeric-method |
Execute a SQL statement on a database connection. |
dbGetInfo,MySQLDriver-method |
Get information about a MySQL driver. |
dbNextResult |
Fetch next result set from an SQL script or stored procedure (experimental) |
dbReadTable,MySQLConnection,character-method |
Convenience functions for importing/exporting DBMS tables |
dbUnloadDriver,MySQLDriver-method |
Unload MySQL driver. |
dbWriteTable,MySQLConnection,character,data.frame-method |
Write a local data frame or file to the database. |
isIdCurrent |
Check if a database object is valid. |
make.db.names,MySQLConnection,character-method |
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. |
result-meta |
Database interface meta-data. |
transactions |
DBMS Transaction Management |
dbListFields
テーブルに含まれるフィールド(列名)を返す
> dbListFields(conn, name, ...)
dbListTables
接続中のデータベース内のテーブルの一覧を返す
> dbListTables(conn, ...)
dbReadTable / dbWriteTable
テーブルの読み書きを行う
> dbReadTable(conn, name, ...)
> dbWriteTable(conn, name, value, ...)
dbSendQuery
クエリーを実行する
> dbSendQuery(conn, statement, ...)