How to write an sql query to update multiple columns of a table using prepared statements?

Question

I have been trying some thing like this:

PreparedStatement ps = connection.prepareStatment("UPDATE table_nm(col1,col2,col3,col4,col5) SET(?,?,?,?,?)");

ps.setString(1, textField1.getText());
ps.setString(2, textField2.getText());
ps.setString(3, textField3.getText());
ps.setString(4, textField4.getText());
ps.setString(5, textField5.getText());
ps.executeUpdate();

May i know what am i doing wrong here. I tried different ways, but none are working. I just want to update all the columns.

Learn basic sql. Your syntax is outright wrong. UPDATE table SET field1=value1, field2=value2, field3=value3, etc — Marc B
– Marc B, Commented Mar 16, 2014 at 5:50
i tried this too but its'nt updating. PreparedStatement ps = connection.prepareStatment("UPDATE table_nm SET col2=?, col3=?, col4=?, col5=? WHERE col1=?"); — Toms
– Toms, Commented Mar 16, 2014 at 6:04
Thanks, the problem was There was no row inserted, i thought updating will automatically add the row. Thanks for the help. Its working when i inserted a row and perform the update statement. — Toms
– Toms, Commented Mar 16, 2014 at 6:16

Ravinder Reddy · Accepted Answer · 2014-03-16 06:03:35Z

2

As commented by @MarcB, the UPDATE statement in your code is wrong:

Change:

UPDATE table_nm(col1,col2,col3,col4,col5) SET(?,?,?,?,?)

To:

UPDATE table_nm 
   SET col1=?, col2=?, col3=?, col4=?, col5=?

Rest of your code seem to be fine.

Refer to: MySQL: UPDATE Syntax

answered Mar 16, 2014 at 6:03

Ravinder Reddy

24.1k6 gold badges54 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

z atef · Accepted Answer · 2014-03-16 06:05:47Z

1

("UPDATE COFFEES SET col1 = ? , col2 =? , col3 =?  and So on .....")

FyI, You can also add where caluse like this WHERE col1 LIKE ?");

 PreparedStatement ps = connection.prepareStatment("UPDATE table_nm SET col1 = ? , col2 =? , col3 =? ")

  ps.setString(1, textField1.getText());
  ps.setString(2, textField2.getText());
  ps.setString(3, textField2.getText());

answered Mar 16, 2014 at 6:05

z atef

7,8263 gold badges60 silver badges55 bronze badges

Collectives™ on Stack Overflow

How to write an sql query to update multiple columns of a table using prepared statements?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related