Member Avatar for kiko11

I want to update a data in my row in the database but it will only add it to the existing data where this existing data is a integer.. example i have a existing data of 100 and my update data is 200.. so the result should be 300... please give me a sample code for this query update in jdbc... thanks

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Ezzaral
Member Avatar for Ezzaral 
update [tableName] set [valueFieldName] = [valueFieldName]+[amount] where [row criteria expression]

Use Statement.executeUpdate() or PreparedStatement.executeUpdate() to execute the update.

Edited by Ezzaral because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.