Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Use UPDATE to Modify Existing Data

- 21.06.26 - ErcanOPAK

✏️ UPDATE = Change Existing Data

Data changes over time. UPDATE modifies existing rows. Be careful — without WHERE, updates all rows.

📝 Basic UPDATE

-- Update single column
UPDATE users SET email = 'newemail@example.com' WHERE id = 123;

-- Update multiple columns
UPDATE users 
SET name = 'Alice Updated', age = 31 
WHERE id = 123;

-- Update with calculation
UPDATE products SET price = price * 1.10 WHERE category = 'electronics';

-- Update with condition
UPDATE orders SET status = 'shipped' 
WHERE order_date < NOW() - INTERVAL '1 day';

-- Update from another table (PostgreSQL)
UPDATE users 
SET name = temp.name, email = temp.email
FROM temp_users temp
WHERE users.id = temp.id;

🎯 Advanced UPDATE

-- Conditional update
UPDATE users 
SET status = CASE 
    WHEN age > 18 THEN 'adult'
    WHEN age > 13 THEN 'teen'
    ELSE 'child'
END;

-- Update with JOIN (PostgreSQL)
UPDATE orders o 
SET status = 'cancelled'
FROM users u
WHERE o.user_id = u.id AND u.status = 'inactive';

-- Increment counter
UPDATE page_views SET view_count = view_count + 1 WHERE page_url = '/home';

-- Update with subquery
UPDATE users 
SET last_order_date = (
    SELECT MAX(order_date) FROM orders WHERE user_id = users.id
)
WHERE EXISTS (SELECT 1 FROM orders WHERE user_id = users.id);

💡 Safety Tips

  • Always use WHERE (or you'll update ALL rows!)
  • Test with SELECT first (see what will be updated)
  • Use transactions for safety (BEGIN; ...; COMMIT;)
  • Backup before mass updates

"Forgot WHERE, updated all rows. Disaster. Now always SELECT first, then UPDATE. WHERE is essential."

— Database Developer

Related posts:

ORDER BY with CASE and UNION in SQL Server

"ORDER BY" with CASE and UNION in SQL Server

Set Identity Insert On/Off in MSSQL

Set Identity Insert On/Off in MSSQL

SQL: Use COALESCE for First Non-Null Value

SQL: Use COALESCE for First Non-Null Value

Views: 9

Post navigation

.NET Core: Understand Routing for URL Mapping
C#: Use Abstract Classes for Shared Behavior

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (661)
  • Add Constraint to SQL Table to ensure email contains @ (619)
  • Average of all values in a column that are not zero in SQL (577)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (553)
  • Find numbers with more than two decimal places in SQL (481)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store
  • WordPress: Fix a Navigation Block Losing Submenu Items After Sync
  • Visual Studio: Fix CodeLens Reference Counts Stuck at Stale Numbers
  • C#: Fix a UTF-8 String Literal Behaving Differently in a Switch
  • Photoshop: Fix a Liquify Mesh Snapping Back on a Smart Object
  • The AI Prompt That Turns a Crash Dump Into a Short Repro Script

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com