Answer / 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

How to get the index of the clicked field in reports in ABAP?

0 Answers   Deloitte,

---

Which design patterns have you used?

0 Answers  

---

whats the Need for Concurrency control

1 Answers  

---

Is class is a abstract datatype in java?

0 Answers  

---

£¢®£ž›;=9:B9<::C = ADITHI HOW TO GET?

0 Answers  

---

Write a shell program where you enter a number which corresponds to K.M. Find out the corresponding values in m, cm, inches, and feet. Hints:- 1 k.m= 1000 m 1 m= 100 cm 1 inches= 2.54 cm. 1 feet= 12 inches

0 Answers  

---

what is the maximam caption size of lebel

1 Answers  

---

What are the limitation in using querystring in .net?

1 Answers   Tesco,

---

can we use commit,rollback in triggers and how?

0 Answers   Sierra Atlantica,

---

I need source code for Enrollment System using Visual Basic 6.0/2008 database MS Access 2007 for my school thesis project...please help me..kindly send in my email jpinedamcp@gmail.com

0 Answers  

---

How to call a C++ function which is compiled with C++ compiler in C code?

0 Answers   Yahoo,

---

Data Structure:  How many comparisons are necessary to find the largest and smallest of a set of n distinct elements?  

0 Answers   Student,

---