I've got the following query in my Java code. But when I run it, it says a syntax error in the query.
What am I doing wrong here?
"Inset into department ( dept_name, dept_desc ) values ('" + deptName + "','" + deptDesc + "')"
marc_s
760k186 gold badges1.4k silver badges1.5k bronze badges
asked Apr 28, 2013 at 4:19
Imesh Chandrasiri
5,67915 gold badges64 silver badges107 bronze badges
2 Answers 2
Its INSERT not Inset . This is a simple typo. Replace the word.
"Inset into department ( dept_name, dept_desc ) values ('" + deptName + "','" + deptDesc + "')"
^^^^^^
answered Apr 28, 2013 at 4:21
Habib
224k30 gold badges420 silver badges446 bronze badges
Sign up to request clarification or add additional context in comments.
Comments
For future reference, as a beginner, using an SQL formatter might help point out the error for nagging issues like these.
answered Apr 28, 2013 at 4:24
user1881190
Comments
default