SQL方言参考
Completion requirements
返回更新
UPDATE
语句的这种变体允许返回受更新影响的行中的值。
Update returning
This variant of UPDATE
statement allows to return the values from the row(s) affected by the update.
Standard | No support in SQL:2003 |
---|---|
DB2 | UPDATE ... RETURNING ... INTO ... since 9.7.
Only returns the updated values, see the documentation. |
Firebird | UPDATE ... RETURNING ... since 2.1.
Can return both old and new values using old. or new. prefixes but for at most one row, see the documentation. |
Ingres | ? |
Linter | ? |
MonetDB | ? |
MSSQL | UPDATE ... OUTPUT ... since MS SQL Server 2005.
Can return both old and new values using inserted. or deleted. prefixes, see the documentation. |
MySQL | No support in 5.7. |
Oracle | UPDATE ... RETURNING ... INTO ...
Supports retrieving values of multiple rows with |
PostgreSQL | UPDATE ... RETURNING ... since 8.2.
Only returns the updated values, see the documentation. |
SQLite | No support in 3.8. |
Virtuoso | ? |
Last modified: Friday, 11 April 2025, 2:33 PM