Google Cloud SQL Update

An SQL statement is used to update one or more rows in a table. You can construct prepared SQL queries by using substitution parameters of the form ?<fieldname> in the query statement.

Each substitution variable identifies an input parameter whose mapped value is substituted at runtime. The type information for the input parameters is fetched from the database using the selected connection for the entered query. Similarly, the input fields in the Input tab of the activity are also populated based on the query.

The following example represents a typical update query:

UPDATE pet SET Name=?Name , Color = ?Color WHERE Species = 'cat';

For the above query, all rows in the 'pet' table have their Name and Colorcolumns are set to the values provided on the Input tab where the species is cat. As usual, all rows satisfying the where clause are updated. If the WHERE clause is omitted then ALL rows are updated. The limit clause can also be used to control this behavior.

It is also possible to use a subquery to derive the values to be used in the update. The subquery format follows the general form:

UPDATE table_name
SET column1 = ?column1, column2 = ?column2...., columnN = ?
columnN
WHERE [condition];

In this case, the parameters supplied are used in the select query that provides replacement values in the outer update statement. The where clause could also be parameterized.