August F.Y. Chao

,

[R Project] How to use R to connect MySql, Step by Step.

In 01 論, 02 備忘錄, 21 碩班課業 on 三月 18, 2008 at 4:00 am
  1. download R from R Project
  2. Update your packages
    1. setting CRAN image
    2. update packages
  3. install RMySQL
  4. google “libmysql.dll”, download it, and extract into R’s directory/lirary/RMySQL/libs
  5. using following command

> library(RMySQL)
> mycon <- dbConnect(MySQL(), user=’cws’, dbname=”cws”, host=”pi”, password=’delores’)
> rs <- dbSendQuery(mycon, “SELECT slide_name FROM arrays limit 5″)
> data1 <- fetch(rs, n = -1)
> data1
slide_name
1 DM1-110
2 DM1-111
3 DM1-112
4 DM1-113
5 DM1-114

You must be logged in to post a comment.