Displaying 1 result from an estimated 1 matches for "testdb3".
Did you mean:
testdb
2012 Feb 06
0
sqsSave() test using Test.R script returning error suggesting no values upon "insert"
...d decided to execute all the tests 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...