在sqlSave命令无法添加数据,原因是增加了ID字段,删除就字段ok了;提示以下错误:Error in sqlSave(channel = connect, dat = FR, tablename = "StockIndex", :
unable to append to table ‘StockIndex’
提交代码:
FR <- data.frame(Power,screen1,IndexLower1,IndexUpper1,screen2,IndexLower2,IndexUpper2,Turnover,IndexType)
sqlSave(channel = connect,dat = FR,tablename = 'StockIndex',append = T,rownames = "ID",addPK = T)