How to avoid "SQL Error 109"?

[ScarFace 01]

Hello friend,

I am getting troubled while solving one error which occurs when trying to run the below mentioned query:

INSERT
temp ( ID,Name, Location, Qualification, Age)
VALUES
(03,'sam', 'Mumbai', BCom)

When I try to run this query I get 'Error 109' and the execution get terminated. I am unable to find the cause of this error. I wonder if you are able make some help in this SQL error.

[opaper]

"SQL Error 109" occurs only when more columns are listed within the "Insert" statement of SQL than values which are mentioned in the VALUES clause. I suggest you to don't assume "Error 109" error as a operating-system error 109. You should make sure that the number of values from the "values"clause must match with the number of columns of the table which is written in the "Insert" SQL statement.

[MindSpace]

Hi friend,

I seems that the number of values from Value clause and Number of column doesn't match. That is you have passed the five number of column while you have pass the values for only four column. To should make this correction in your query to avoid "Error 109". The number of column and values must be identical. See below example:

INSERT
t1 (col1,col2,col3)
VALUES (val1,val2,val3)

[Modifier]

Hello

I suggest you to try following query instead of your query. You query sounds faulty. Use following query and let me know if you are still getting "Error 109" or not. Hopefully it will run successfully:

insert
temp (ID,Name, Location, Qualification, Age)
values
(04,'Lana', 'Landon', 'Bcom', 25)

[Praetor]

You need to check the SQL query statement syntax near the syntax element which mentioned within the error message. The you also need to check the entire SQL query statement which cause this error. It may happen because the the syntax of the sql query sometimes may be quit complex. The order of the SQL statement is also important. Id the the order of statements is not proper then it also generates a error.

[ScarFace 01]

Hello friend,

Thanks for all your help over this "SQL Error 109". Yes you was correct the problem was in the number of column and values. When I checked my query statement I found that the value for one column is missing. Then I re-execute the same query withe additional value for missing column. And hopefully I executed without any error. Now I don't get any error while running the mentioned query of insert.