Displaying 1 result from an estimated 1 matches for "ch4dd".
Did you mean:
cfqdd
2010 Mar 10
0
RMySQL_0.7-4 core dumped on dbWriteTable
...ges:
[1] stats graphics grDevices utils datasets methods base
> library(RMySQL)
Loading required package: DBI
> con<- dbConnect(dbDriver("MySQL"), dbname = "knottlf_local",user="mysql", password="xxxxxx", host="localhost")
> ch4dd<-data.frame(6,"2010-03-06")
> names(ch4dd)<-c("scada_terminal_id","timestamp_on")
> ch4dd
scada_terminal_id timestamp_on
1 6 2010-03-06
> dbGetQuery(con, "SELECT LAST_INSERT_ID() FROM `knottlf_local`.`R_ch4_concentrations`")...