Inserting data into Database and Error in executeUpdate() method

Question

PreparedStatement ps;
String query = "INSERT INTO order (table_id,dish_id,price,count) VALUES (?,?,?,?)";
try {
    con = DBHelper.getCon();
    ps = con.prepareStatement(query);
    ps.setInt(1, order.getTable_id());
    ps.setInt(2, order.getDish_id());
    ps.setInt(3, order.getPrice());
    ps.setInt(4, order.getCount());
    result = ps.executeUpdate();
...

I have error in executeUpdate() method. It shows

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near error.

How can I fix it?

How did you create table ORDER? I tried and got an error. See this db fiddle — Abra
– Abra, Commented Oct 6, 2020 at 5:35

Ayush28 · Accepted Answer · 2020-10-06 04:57:21Z

1

In your SQL statement, order is understood as the incomplete SQL keyword ORDER BY.

I would suggest you to rename the tablename to orders to remove the ambiguity.

answered Oct 6, 2020 at 4:57

Ayush28

3793 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Abra Over a year ago

According to your answer, it would be impossible to create table ORDER in the first place, wouldn't it?

Ayush28 Over a year ago

I would suggest you to read and follow SQL naming conventions to avoid such discrepancies. It's not about being impossible, but defining everything in an unambiguous and absolute manner.

Emily Watson Over a year ago

Thanks for your suggestions.It works.Now there is no error.

dreamcrash Over a year ago

@EmilyWatson Why did you remove my accepted answer in the other thread? could you give me an upvote?

Emily Watson Over a year ago

I am new user of Stackoverflow. Sorry. I will upvote.

Collectives™ on Stack Overflow

Inserting data into Database and Error in executeUpdate() method

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related