Forum: Building VoltDB Applications

Post: Update statement

Update statement
BlitzDog
Jul 2, 2012
Is this update statement supported:
UPDATE TABLEA
SET b = TABLEB.b1,
FROM TABLEA, TABLEB
WHERE TABLEA.a = TABLEB.a1
OK, let me rephrase the
BlitzDog
Jul 3, 2012
OK, let me rephrase the question: Which option below is the right way to solve this problem:
1. I should be able to execute an update statement that can fill in values in a table from a different table, I just have the SQL statement wrong.
2. I have to loop through the result of a SELECT statement and use the values for individual UPDATE statements, all within a one stored procedure.
I believe you have to use
rbetts
Jul 3, 2012
OK, let me rephrase the question: Which option below is the right way to solve this problem:
1. I should be able to execute an update statement that can fill in values in a table from a different table, I just have the SQL statement wrong.
2. I have to loop through the result of a SELECT statement and use the values for individual UPDATE statements, all within a one stored procedure.


I believe you have to use approach (2).
Ryan.