A
A
Andrey Lubchuk2016-01-16 00:40:17
MySQL
Andrey Lubchuk, 2016-01-16 00:40:17

How to remove an error when processing an INSERT query in SQL. JAVA?

I have a request to add to the database

INSERT INTO products" + "(name, quantity, price, replace) VALUES" + "(?, ?, ?, ?)
. But it keeps throwing an error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'replace) VALUES('w', 1.0, 1.0, 'w')' at line 1

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
sivabur, 2016-01-16
@sivabur

replace -keyword campaign.

D
Dmitry Skogorev, 2016-01-16
@EnterSandman

(`name`, `quantity`, `price`, `replace`)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question