Dear Prof. Ripley et al.,
I have a data frame with some variable names that contain the underscore
character ('_'). It seems that RODBC is not converting them to a suitable
variable name for MySQL.
sqlSave(channel, zz, addPK = TRUE, verbose = TRUE)
Query: CREATE TABLE zz (rownames
I would like to make one of the columns in a data frame the primary key.
Using RODBC it seems that it always specifies a numerical index 'rownames'
and you only have a choice of renaming that variable (rownames = char) and
setting it as the primary key (or not). I would like to not have this
I've discovered that the problem in this command is the use of 'GROUP' as a
column name. Within mysql, we get the same error with:
mysql create table tmp ( group varchar(20) );
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for
I had a similar problem when I posted this recently:
RODBC and Excel: Wrong Data Type Assumed on Import
http://tolstoy.newcastle.edu.au/~rking/R/help/05/11/14938.html
My conclusion was: Being lucky shouldn't be part of processing Excel
files, which is the case when RODBC is used.
This reply
I am using the RODBC package to read data from an Excel file. An excerpt of
the file looks like this:
00103V206 AES Corporation 6.00% 42.87
00808N202 AES Trust III 6.75% 34.98
03748R861 Apartment Investment Management 9.00% #ERROR (I)
039380209 Arch Coal, Inc.