java.sql.SQLException: Column count doesn't match value count at row 1

Question

I'm trying to update values using JDBC and I continue to get the same error for different tables and with different schemas. Let's say that I have a table like this ``` +----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+-------+ | field1 | varchar(50) | YES | | NULL | | | field2 | varchar(50) | YES | | NULL | | +----------------+-------------+------+-----+---------+-------+ ``` then, I try to add a row: ``` String Text1 = text1; String Text2 = text2; String Query_String = "INSERT INTO tablename(field1,field2) VALUES ('"+Text1+","+Text2+"')"; Query_Statement.executeUpdate(Query_String); ``` 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" I'm sure it's something simple, probably on the syntax since I managed to make it to work with a…

Accepted Answer

There is something wrong with:

```
String Query_String = "INSERT INTO tablename(field1,field2) VALUES ('"+Text1+","+Text2+"')";
```

You've missed some quotes between Text1 and Text2:

```
String Query_String = "INSERT INTO tablename(field1,field2) VALUES ('"+Text1+"','"+Text2+"')";
```

java.sql.SQLException: Column count doesn't match value count at row 1

Solution

Problem