title: Insert DataFrame into SQL table with AUTO_INCREMENT column
body: <p>I have a MySQL table which includes a column that is <code>AUTO_INCREMENT</code>:</p>
  
  <pre><code>CREATE TABLE features (
    id INT NOT NULL AUTO_INCREMENT,
    name CHAR(30),
    value DOUBLE PRECISION
  );
  </code></pre>
  
  <p>I created a <code>DataFrame</code> and wanted to insert it into this table.</p>
  
  <pre><code>case class Feature(name: String, value: Double)
  val rdd: RDD[Feature]
  val df = rdd.toDF()
  df.write.mode(SaveMode.Append).jdbc("jdbc:mysql://...", "features", new Properties)
  </code></pre>
  
  <p>I get the error, <code>Column count doesn’t match value count at row 1</code>. If I delete the <code>id</code> column it works. How could I insert this data into the table without changing the schema?</p>