This page describes how to update data in Big Query.
Note that DML in Big Query has some limitations and known issues.
Compound assignment operator: = Add and assign -= Subtract and assign *= Multiply and assign /= Divide and assign %= Modulo and assign &= Bitwise AND and assign ^= Bitwise XOR and assign |= Bitwise OR and assign Returns updated data or expressions based on it as part of the UPDATE operation.The OUTPUT clause is not supported in any DML statements that target remote tables or views.In other words, a target row shouldn't join to more than one row from the other table(s).If it does, then only one of the join rows will be used to update the target row, but which one will be used is not readily predictable.However, each UPDATE statement can have only one WHERE clause.
The following UPDATE statements result in different population increases for different countries in the NEWCOUNRTRIES table.
For more information, see OUTPUT Clause (Transact-SQL).
FROM Specifies that a table, view, or derived table source is used to provide the criteria for the update operation. If the object being updated is the same as the object in the FROM clause and there is only one reference to the object in the FROM clause, an object alias may or may not be specified.
By commenting, you are accepting the IBM commenting guidelines and the DISQUS terms of service.
The UNDO _POLICY= option in the PROC SQL and RESET statements determines how PROC SQL handles the rows that have been inserted or updated by the current INSERT or UPDATE statement up to the point of error.