MySQL Syntax error | You have an error in your SQL syntax;

Question

Error:

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 'lock WHERE player='SrLolok'' at line 1

Code:

PreparedStatement search = instance.getConnection().prepareStatement("SELECT * FROM lock WHERE player=?;");
search.setString(1, player);
ResultSet rs = search.executeQuery();

The error message you got has a big clue that the problem is with the word "lock", because it's the first part of what it shows you in the query: ...syntax to use near 'lock WHERE .... The part right after "near" is usually a good indicator of something you're doing wrong. — Kaan
– Kaan, Commented Jan 28, 2020 at 17:16

GMB · Accepted Answer · 2020-01-28 16:46:49Z

5

lock is a reserved word in MySQL.

If you want to use it, you need to surround it with backticks:

SELECT * FROM `lock` WHERE player=?

Or better yet, use a table name that does not correspond to a reserved word, so you don't need to worry about this.

answered Jan 28, 2020 at 16:46

GMB

224k25 gold badges103 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

MySQL Syntax error | You have an error in your SQL syntax;

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