- Read & Write Function <code>read.table()</code> and <code>write.table()</code>. ``` read.table(file, header = FALSE, sep = "", quote = "\"'", dec = ".", row.names, col.names, as.is = FALSE, na.strings = "NA", colClasses = NA, nrows = -1, skip = 0, check.names = TRUE, fill = !blank.lines.skip, strip.white = FALSE, blank.lines.skip = TRUE, comment.char = "#") write.table(x, file = "", append = FALSE, quote = TRUE, sep = " ", eol = "\n", na = "NA", dec = ".", row.names = TRUE, col.names = TRUE, qmethod = c("escape", "double")) ``` - Load & Save Function <code>read.table()</code> and <code>write.table()</code>. ``` load(file, envir = parent.frame()) save(..., list = character(0), file = stop("`file' must be specified"), ascii = FALSE, version = NULL, envir = parent.frame(), compress = FALSE) ``` - Download for MySQL - For MS Windows: - R 1.6 and Mysql 3.x, DBI.zip or my mirror <a href="./source/data/DBI.zip">here</a>, RMySQL.zip (my mirror <a href="./source/data/RMySQL.zip">here</a>). - R 1.7 and Mysql 3.x or 4.x, DBI_0.1-5.zip or my mirror <a href="./source/data/DBI_0.1-5.zip">here</a>, RMySQL_0.5-1.zip (my mirror <a href="./source/data/RMySQL_0.5-1.zip">here</a>). - R 1.8 and Mysql 3.x or 4.x, DBI_0.1-8.zip or my mirror <a href="./source/data/DBI_0.1-8.zip">here</a>, RMySQL_0.5-5.zip (my mirror <a href="./source/data/RMySQL_0.5-5.zip">here</a>). - For Linux: - For R 1.7 and Mysql 3.x or 4.x, DBI_0.1-7.tar.gz or my mirror <a href="./source/data/DBI_0.1-7.tar.gz">here</a>, RMySQL_0.5-2.tar.gz (my mirror <a href="./source/data/RMySQL_0.5-2.tar.gz">here</a>). - MySQL Require packages <code>methods</code>, <code>DBI</code>, <code>RMySQL</code>. ``` # In Windows, require add the RMySQL.dll to PATH, like this # Sys.putenv(PATH = paste(Sys.getenv("PATH"), # "C:/PROGRA~1/R/rw1071/library/RMySQL/libs/", sep = ";")) library(methods) library(DBI) library(RMySQL) db <- NULL db$info <- list(driver = "MySQL", user = "yourname", password = "yourpassword", host = "yourdbhost", port = "yourdbport") db$drv <- dbDriver(db$info$driver) db$con <- dbConnect(db$drv, user = db$info$user, password = db$info$password, host = db$info$host, port = db$info$port, dbname = "whatyouwant") tb <- NULL tb$get <- dbGetQuery(db$con, paste("select * from table where field = \"", value, sep = "")) dbDisconnect(db$con) dbUnloadDriver(db$drv) ``` - More - Another database, ODBC, PostgreSQL, Oracle, .... - See <a href="http://developer.r-project.org/db/" target="_blank">R & DBMSs Page</a> --- <div w3-include-html="../preamble_tail_date.html"></div>