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

what is woransient key word? how it is used in java

0 Answers   Convergys,

---

Diff.b/w Frames and container?

1 Answers   Tech Mahindra, Wipro,

---

What is the first message line that any language learning prints on the screen? and why?

0 Answers  

---

what are the top level class of interface in java?

2 Answers   Satyam,

---

why we use static with only main()class not with other class

2 Answers   TCS,

---

Need provab technical test questions

0 Answers  

---

How to call static method in Java?

2 Answers   Epoch,

---

where is available in this mantis toturials?

0 Answers  

---

how does database connection using ADO.NET?

0 Answers  

---

3. What is the difference between testing and Quality Assurance?

0 Answers  

---

Explain three modes in which files can be accessed from python program

0 Answers   Peerless,

---

In Java what is the difference between following two statements ? int a[],b; int []a,b;

1 Answers  

---