MySQL Syntax Error INSERT INTO and WHERE statements

Question

I have created a database table with 4 columns

user , password , ipaddress , isVIP

I would like to insert the data to ipaddress where user = ? and password =?

I tried using this mySQL syntax

PreparedStatement ps = con.prepareStatement("INSERT INTO login(ipaddress) VALUES(?) select * from login where user=? and password=?");
        ps.setString(1,ipaddress);
        ps.setString(2,id);
        ps.setString(3, password);

Which it tells me that I have syntax error.

I think you look for `INSERT INTO login(ipaddress, user, password) values(?,?,?)` — juergen d, Jan 03 '17 at 14:25
Required reading: [Best way to store password in database](http://stackoverflow.com/q/1054022/335858). — Sergey Kalinichenko, Jan 03 '17 at 14:28

score 2 · Accepted Answer · answered Jan 03 '17 at 14:25

Your INSERT is not syntactically correct. Even when you fix it your INSERT will not work because you are selecting and inserting into the same table! That is not allowed in mysql.

You will need to use an update instead.

con.prepareStatement("UPDATE login SET ipaddress = ? WHERE user=? and password=?");

score -1 · Answer 2 · answered Jan 03 '17 at 14:53

-1

Can you try with below one.

 PreparedStatement ps = con.prepareStatement("INSERT INTO login(ipaddress) VALUES select ipaddress from login where user=? and password=?");
            ps.setString(1,id);
            ps.setString(2, password);

answered Jan 03 '17 at 14:53

rsh

69
4

MySQL Syntax Error INSERT INTO and WHERE statements

2 Answers2