Displaying 1 result from an estimated 1 matches for "datetime_9".
2003 Nov 24
1
RMySQL valid field names
...I have a data frame which has among others three columns with names
('DateTime', 'Open' and 'Close'). When I use dbWriteTable to dump the data
frame into a MySQL database everything works fine except the names of these
three columns which are slightly different (e.g. 'DateTime_9').
This only occurs with these 3 columns because their names are reserved words
of MySQL. The change of names is occurring in the function mysqlWriteTable,
namely in the call:
...
names(field.types) <- make.db.names(con,names(field.types),allow.keywords=F)
...
If I change the parameter a...