Local Variables and update Statements

You can assign variables directly in an update statement. You do not need to use a select statement to assign a value to a variable. When you declare a variable, it has the value NULL.

See the Reference Manual: Commands.