Update column value and return updated value in same query MySQL, Java

Question

I know similar questions exist in which the user is trying to retrieve key generated of new row and the same thing as i want in PHP but i want to know its alternate for java. This is what i want:

String query = "UPDATE table SET tabValue = (tabValue+number) WHERE id="+xyz;

I want to retrieve the tabValue after it is being updated in the same query! Is it possible or do i have to write another query for it? Can anyone help me out here please? NOTE: I am using JDBC.

phpMyAdmin is the administration tool. you are using MySQL. I think you have to use a StoredProcedure for your solution. — nano_nano
– nano_nano, Commented May 26, 2015 at 9:15
In java you can get AUTO_INCREMENT field (dev.mysql.com/doc/connector-j/en/…), but not an any field from insert/update statement. — agad
– agad, Commented May 26, 2015 at 9:27

Tim Biegeleisen · Accepted Answer · 2015-05-26 09:19:39Z

1

From the MySQL documentation:

Currently, you cannot update a table and select from the same table in a subquery.

You cannot refer to the table which is being updated in a FROM clause.

You are better off just keeping track of what the new value will be after UPDATE in your Java code.

answered May 26, 2015 at 9:19

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

Update column value and return updated value in same query MySQL, Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related