|
|
R 教材:資料讀取 |
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(file, envir = parent.frame()) | |
save(..., list = character(0), file = stop("`file' must be specified"),
ascii = FALSE, version = NULL, envir = parent.frame(),
compress = FALSE)
|
# In Windows, need 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)
|
![]() |
![]() |
| 陳韋辰 (04/08/19) --- |