Displaying 1 result from an estimated 1 matches for "testdb5".
Did you mean:
testdb
2012 Feb 06
0
sqsSave() test using Test.R script returning error suggesting no values upon "insert"
...provided in "Test.r" under the unpacked package RODBC folder.
Beginning with the following:
library(RODBC)
library(MASS)
USArrests[1,2] <- NA
hills <- hills[1:15,]
row.names(hills)[12] <- "Dollar ('$')"
set.seed(1)
# MySQL
## testdb3 is ODBC/Connector 3.51.x, testdb5 is 5.1.x
channel <- odbcConnect("MysqlODBC") #my database
odbcGetInfo(channel)
sqlTypeInfo(channel)
sqlTables(channel)
sqlDrop(channel, "test.USArrests",errors = FALSE) #explicit database AND table call as MySQL doesn't allow general table creation
Everything works...