What is wrong with my database code?

Question

I'm trying to check if my String key is in the NETFLIX column.

public boolean checkSerial(String key){
    boolean isValid = false;
    sql = "Select * from KEYS WHERE NETFLIX=?";
    try{
        ps = con.prepareStatement(sql);
        ps.setString(1, key);
        rs = ps.executeQuery();
        if(rs.next())
            isValid = true;
    }catch(SQLException e){
        System.out.println(e);
    }
    return isValid;
}

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'KEYS WHERE NETFLIX='IPMAN'' at line 1

have you tried using ";" at the end?

Aakash
– Aakash

2015-06-01 06:18:37 +00:00
Commented Jun 1, 2015 at 6:18 — Aakash
– Aakash, Commented Jun 1, 2015 at 6:18

The Coder · Accepted Answer · 2015-06-01 07:56:48Z

9

KEYS is a MySQL reserved keyword. So possibly you'll get an error even if there's nothing wrong with the query.

Either you've to avoid using MySQL reserved keywords, which can be found at

https://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

or

Use appropriate quotes for the keywords if you don't want to change your existing table. Like,

Select * from `KEYS` WHERE NETFLIX=?

Note: It's not a single quote, it's a symbol which is present along with the tilde symbol below the escape button (It's called backtick according to comment).

edited Jun 1, 2015 at 7:56

answered Jun 1, 2015 at 6:25

The Coder

2,6426 gold badges38 silver badges62 bronze badges

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

1 Comment

user1038550 Over a year ago

That symbol is the backtick, or grave accent.

Collectives™ on Stack Overflow

What is wrong with my database code?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related