My first RMySQL session
# 'fai1' is an empty MySQL database for which 'mpromber' has all privileges mycon <- dbConnect(MySQL(),user='mpromber',dbname='fai1') # pass seems to be read from ~/.my.cnf # dsub is a data frame: dbWriteTable(mycon,"dsub",dsub) # create table "dsub" dbDisconnect(mycon) # close connection
Time for lunch.