[client]
default-character-set = utf8
[mysqld]
skip-character-set-client-handshake
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8
[mysqldump]
default-character-set = utf8
[mysql]
default-character-set = utf8
- Sequel Proを使って読み込み
- テーブルを作る
- File>Importから読み込み
library(RMySQL)
drv<-dbDriver("MySQL")
conn<-dbConnect(drv,user="ユーザー名", password="パスワード", dbname="データベース名")
d<-dbReadTable(conn,"Table名")
dbDisconnect(conn)
summary(d)
ID name disease age male
Min. : 62170 Length:66 Length:66 Min. :38.00 Min. :0.0000
1st Qu.:1229233 Class :character Class :character 1st Qu.:63.00 1st Qu.:0.0000
...