---
title: "SQL UPDATE Query"  
description: "SQL UPDATE Query"  
author: "Anonymous User"  
published: 2015-11-24  
updated: 2015-11-24  
canonical: https://www.mindstick.com/forum/33633/sql-update-query  
category: "database"  
tags: ["database", "sql server", "sql"]  
reading_time: 1 minute  

---

# SQL UPDATE Query

I want to use [UPDATE](https://www.mindstick.com/forum/156353/what-is-hummingbird-update) [Query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver) in [sqlserver](https://www.mindstick.com/forum/33737/between-condition-in-sqlserver) please help me.

## Replies

### Reply by Anonymous User

The SQL UPDATE Query is used to modify the existing records in a table.\
You can use WHERE clause with UPDATE query to update selected rows otherwise all the rows would be affected.

```
 UPDATE Customer
SET City='Allahabad' where City='allibaba'
SELECT * FROM Customer
```

![SQL UPDATE Query](https://www.mindstick.com/mindstickforums/ed827cd4-aedf-4ed7-8209-a3121c9e989e/images/cf413f23-cd06-4af9-bcc1-62641d96ddab.png)


---

Original Source: https://www.mindstick.com/forum/33633/sql-update-query

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.