SQL UPDATE Function
Quick summary: The SQL UPDATE statement modifies existing rows in a table.
SQL UPDATE Syntax
UPDATE table_name SET column1 = value1, column2 = value2 WHERE conditionSQL
SQL UPDATE Basic examples
UPDATE users SET active = 1 WHERE id = 5;SQL
Output:
1 row updatedUpdates a single row.
SQL UPDATE Real-world usage
UPDATE orders SET status = 'expired' WHERE created_at < NOW() - INTERVAL 30 DAY;SQL
Output:
Multiple rows updatedBulk updates old records.
SQL UPDATE Edge cases
UPDATE users SET active = 0;SQL
Output:
All rows updatedMissing WHERE updates the entire table.
SQL UPDATE Common mistakes
Forgetting the WHERE clause
Updates all rows unintentionally.
Incorrect
UPDATE users SET active = 0;Correct
UPDATE users SET active = 0 WHERE last_login < '2025-01-01';Always verify conditions.
SQL UPDATE Frequently Asked Questions
What does UPDATE do in SQL?
Modifies existing rows in a table.
Basic syntax of UPDATE?
UPDATE table SET column=value WHERE condition.
Use case?
Updating records.
Common mistake?
Forgetting WHERE clause.
Handles multiple rows?
Yes.
Performance?
Depends on indexes.
Safe?
Use transactions.
Rollback possible?
Yes.
Used with JOIN?
Yes in some DBs.
Handles NULL?
Yes.
Alternative?
DELETE + INSERT.
Best practice?
Always use WHERE.