title: java.sql.SQLException: Column count doesn't match value count at row 1
body: <p>I'm trying to update values using JDBC and I continue to get the same error for different tables and with different schemas.</p>
  
  <p>Let's say that I have a table like this</p>
  
  <pre><code>+----------------+-------------+------+-----+---------+-------+
  | Field          | Type        | Null | Key | Default | Extra |
  +----------------+-------------+------+-----+---------+-------+
  | field1         | varchar(50) | YES  |     | NULL    |       |
  | field2         | varchar(50) | YES  |     | NULL    |       |
  +----------------+-------------+------+-----+---------+-------+
  </code></pre>
  
  <p>then, I try to add a row:</p>
  
  <pre><code>String Text1 = text1;
  String Text2 = text2;
  String Query_String = "INSERT INTO tablename(field1,field2) VALUES ('"+Text1+","+Text2+"')";
  Query_Statement.executeUpdate(Query_String);
  </code></pre>
  
  <p>the number of columns is the same, and also in the text there are not other commas, but I continue to get the error "java.sql.SQLException: Column count doesn't match value count at row 1"</p>
  
  <p>I'm sure it's something simple, probably on the syntax since I managed to make it to work with a single column...</p>
  
  <p>Thanks in advance</p>