title: How to change a value in a table with already fulfilled values?
body: <p>I have a table in which there are 13 columns. From these 13 columns I need to replace a previous value with the updated one which is in line 11.</p>
  
  <pre><code>if (Integer.parseInt(res.getString("res_id")) == res_id) {
      if (Integer.parseInt(res.getString("rem_pay")) &gt; 0) {
          String a = res.getString("rem_pay");
          System.out.println("You need to pay the remaining amount: " + a);
          System.out.println("How much you want to pay?");
          amount=scanner.nextDouble();
          String query1= "INSERT INTO reservations values()"; //Changing the old rem_pay with the new one which the variable amount
          amount=Double.parseDouble(res.getString("rem_pay"))-amount;
  </code></pre>
  
  <p>Any answer will be really helpful.</p>