Syntax error in sql statement?

Question

I am getting a syntax error in the following lines. I am not familiar with mysql so any pointers will be helpfull

 ps = con.prepareStatement("INSERT INTO order(status,ordered_on,total_price,user_id) "
                + " VALUES(?,?,?,?)");

        ps.setString(1,"pending");
        ps.setTimestamp(2,date);
        ps.setDouble(3,total_price);
        ps.setInt(4,ID);

The error was MySQL server version for the right syntax to use near 'order(status,ordered_on,total_price,user_id) VALUES('pending','2017-03-22 04:08' at line 1

Try removing the concatenation in the query to start. If that doesn't work try inserting just status (remove rest of vars to simplify things) — hendr1x
– hendr1x, Commented Mar 21, 2017 at 22:53
you have two spaces between ") VALUES" and no space after values — Judith Palacios
– Judith Palacios, Commented Mar 21, 2017 at 22:54
order is a reserved word. Enclose it in "`" if you are referring to a table with the same name like `order`. — Carsten Massmann
– Carsten Massmann, Commented Mar 21, 2017 at 22:58

kourouma_coder · Accepted Answer · 2017-03-21 23:08:40Z

1

The problemis that order is a reserved keyword for mysql ; so you have two solutions at your disposal 1 : if you are required some raison to use that work in case you case use backtick escapes `order`
2 : you can use plural for the tables name like orders

    ps = con.prepareStatement("INSERT INTO `order`(status,ordered_on,total_price,user_id) "
            + " VALUES(?,?,?,?)");

    ps.setString(1,"pending");
    ps.setTimestamp(2,date);
    ps.setDouble(3,total_price);
    ps.setInt(4,ID);

This is q link to the mysal reserved keywords

edited Mar 21, 2017 at 23:08

answered Mar 21, 2017 at 23:02

kourouma_coder

1,1082 gold badges13 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Syntax error in sql statement?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related