SQL UPDATE Statement Syntax and Examples

March 17, 2023 작성자: Beekeeper Studio Staff

Description

Changes existing data in a table.

Syntax

UPDATE { table_name | view_name }
SET { column_name = expression } [ ,…n ]
[ FROM { table_name | view_name } [ ,…n ] ]
[ WHERE < search_condition > ]

Example

UPDATE table1
SET c1 = 9

Detail

UPDATE permissions default to members of the sysadmin fixed server role, the db_owner and db_datawriter fixed database roles, and the table owner. Members of the sysadmin, db_owner, and db_securityadmin roles, and the table owner can transfer permissions to other users.

SELECT permissions are also required for the table being updated if the UPDATE statement contains a WHERE clause, or if expression in the SET clause uses a column in the table.

SELECT (SQL Statement)

DELETE (SQL Statement)

INSERT (SQL Statement)