The ability to put table-name qualifiers in front of the column names in the SET clause of an UPDATE statement is a MySQL-ism. I'm not aware of any SQL engine other than MySQL that supports that syntax.
The ability to put table-name qualifiers in front of the column names in the SET clause of an UPDATE statement is a MySQL-ism. I'm not aware of any SQL engine other than MySQL that supports that syntax.