System.out.println("Enter new name: "); String stdName = input.readLine(); st.executeUpdate("UPDATE Customers SET stud_name='"+stdName+"' WHERE stud_ID='45698'");
Ok, this is my problem, this command should update\replace the existing column stud_name with a new name. But it wasn't able to replace it. There were no sql errors.
Did I miss anything? Or are there any suggestions?