Question

sql语句问题：这条语句执行后并没有操作到数据库里面，是不是语法上有问题？

String sql2 = "delete from useraddress where LoginID = (select LoginID from useraccount where username = ?)";
ps2 = conn.prepareStatement(sql2);
ps2.setString(1, uname);
ps2.executeUpdate();
求懂得的帮解答一下。。

Answer 1

String sql2 = "delete from useraddress where LoginID in (select LoginID from useraccount where username = ?)";
ps2 = conn.prepareStatement(sql2);
ps2.setString(1, uname);
ps2.executeUpdate();