MySQL query error from Java

Question

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 + "')"

Habib · Accepted Answer · 2013-04-28 04:21:57Z

4

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

user1881190 · Accepted Answer · 2013-04-28 04:24:21Z

1

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