title: SqlSave Error: Unable to append to table
body: <p>Code:</p>
  
  <pre><code>sqlSave(SQL,data.frame(df),tablename='Data',append = TRUE,rownames = FALSE)
  </code></pre>
  
  <p>The table in which I am trying to insert the data has a primary key which is auto-increment. My table has a total of 5 columns including the primary key. In my data frame, I have 4 columns because I don't want to insert the PK myself. However, when I run the command, I get the following error:</p>
  
  <p><em>Error in <code>colnames&lt;-</code>(<code>*tmp*</code>, value = c("BId", "name", "Set",  : 
    length of 'dimnames' [2] not equal to array extent</em></p>
  
  <p>Also, when I insert the Primary key in the dataframe by myself, it still doesn't work.</p>
  
  <p><em>Error in sqlSave(SQL, data.frame(df), tablename = "Data",  : 
    unable to append to table ‘Data’</em></p>