如：在数据库添加ID字段，字段属性

在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)