Answer Posted / poopapule

The UPDATE statement allows you to update a single record
or multiple records in a table.

The syntax for the UPDATE statement is:

UPDATE table
SET column = expression
WHERE predicates;



Example #1 - Simple example

Let's take a look at a very simple example.

UPDATE suppliers
SET name = 'HP'
WHERE name = 'IBM';

This statement would update all supplier names in the
suppliers table from IBM to HP.



Example #2 - More complex example

You can also perform more complicated updates.

You may wish to update records in one table based on values
in another table. Since you can't list more than one table
in the UPDATE statement, you can use the EXISTS clause.

For example:

UPDATE suppliers
SET supplier_name = ( SELECT customers.name
FROM customers
WHERE customers.customer_id = suppliers.supplier_id)
WHERE EXISTS
( SELECT customers.name
FROM customers
WHERE customers.customer_id = suppliers.supplier_id);

Whenever a supplier_id matched a customer_id value, the
supplier_name would be overwritten to the customer name
from the customers table.



-pooja papule

any drawback are there in mantis?

2209

---

what is the diffrence between software and hardware language?

2384

---

As per interoperatbility programs written in one language can be used by other language. How can we restrict the features of one language (say C#) in the programmer written in another language (say VB)..for example we have some features like operator overloading which is possible C#.NET (not in VB.NET), how can we restrict that when we are using this code in VB.NET.

2013

---

What binary value will be internally stored for NULL for the type S9(1) COMP 3 in mainframe

2022

---

What's the difference b/w Table & Templete in Smartform?

2307

---

I want to pass .pdf files as OlE Object to crystal report through VB6. Please any one guid me...

3090

---

In project we have Documentation phase also,in that what is micro and macro designing?

1901

---

how many types of operating system are avaliable?

2406

---

Hi I am Rathnam, How To Remove the duplicates with out using remove duplicate stage in the datastage

1995

---

what is programmable BIST in today ic design

2197

---

how many types of bytes are there???

2621

---

Give examples of macro quoting function?

2050

---

how do find the user exit for selected feild whatis the process and can u plz explain it

2193

---

what is apt_dump_score in datastage where it is useful

2011

---

Tips for blog integration by www.esteemwebsolutions.com. Can Any body suggest me to how to make wonderful questions on web integration..

2305

---