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

Write a program to show polymorphism.

1115

---

How to connect to ms word wit VB ojective is to prepare s/w to generate question paper , selects questions randomly from the ms access , database

2465

---

I'm new to ABAP. What is Module pool in SAP?

2584

---

write a sql qwery which include joining of two tables 4 marks mainframe

1932

---

How can we develop a multi-tier application in Java?

1894

---

How do you pass variables forwrd to future CECI sessions

4507

---

I am looking for selenium RC online Training in chennai. can any one tell me the best institute

1964

---

why not instantiating servet using new operator?

1956

---

what is session state?

1954

---

Write a program to reverse a number?

1178

---

Can anyone send me NIC question papers alongwith answers on nidhi1485@yahoo.co.in? Urgently needed.. Thanks in advance

2376

---

What is web.configuration? how is it work? & wht is use this?

1868

---

SAS question: I have 50 fils a1,a2,...,a50. the primary key is upc. then if i want to merge all 50 files, the code is as follows, data test; merge a1 ... a50; by upc; run; we know that writing all 50 files name is time consuming, is there any standard format of this code?

1942

---

what is the last ant version you worked?how to get it

1947

---

why we use mantis? what u mean mantis in IT trends? addvantages of mantis?

2217

---