SQL UPDATE — Basic UsageIT technician command center
● ITSign inMembers
Database · SQL and Database Administration

SQL UPDATE — Basic Usage

Use SQL UPDATE for a standard administrative task.

Copy-ready commandSQL UPDATE — Basic Usage
UPDATE users SET enabled = 0 WHERE id = 42;
Production warning

INSERT, UPDATE, DELETE, ALTER, and restore operations can modify or remove data.

Requirements and permissions

Requirements
Appropriate database client and connection
Permissions
Database privileges vary
Last reviewed
2026-07-31

Examples

Basic Usage

Use SQL UPDATE for a standard administrative task.

UPDATE users SET enabled = 0 WHERE id = 42;

Original command

Update matching rows.

UPDATE users SET enabled = 0 WHERE id = 42;

Common errors

Command not found

Confirm Appropriate database client and connection is installed and available in your current shell.