'SQL Insert Query With Condition Exception [closed]

I have this query:

 String requete = "INSERT INTO reduction(newPrix) VALUES (?) "
                        + "WHERE id_prom=? AND id_prod=?";

I am getting an exception:

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 'WHERE id_prom=2 AND id_prod=6' at line 1

I'm wondering why the INSERT query was failing. Any advise appreciated.

sqlmariadb


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions