This article is tagged with:
Sql update alias
and mysql
sql update alias
UPDATE t
SET t.COLUMN = 'UPDATE'
FROM DATABASE_TABLE t
WHERE t.ID = 1;