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

List and explain any five built in functions for Lists data type in python

1 Answers   Peerless,

---

is try block possible without catch block?

3 Answers  

---

Define Form modules, Class modules and Standard modules

0 Answers   Global Hunt,

---

class A{ void me(){s.o.p("");} class B extends A{ void me() {s.o.p(" ");} class M{ A a=new B(); B b=new A(); a.me(); b.mne();} what is the output of this, how?

2 Answers   Cosmos, HyTech Pro, WinSoft,

---

in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'

0 Answers   Infosys,

---

What are two of your strengths that you will bring to our QA/testing team?

0 Answers  

---

Hi guys... I have one doubt ..Exception is a runtime error then why we have checked exception... Thanks in advance

2 Answers  

---

How many types of list exist in the HTML

2 Answers  

---

a characteristic of a multiprogramming is? a.simultaneous exe of pgm instr 4m 2 appli b.concurrent processing of 2 r more prgms c.multiple cpu s d.all the abov

0 Answers   TCS,

---

When you deliver your C++ headers and C++ library of a class (what all can you change in the class so that application using your class does not need to recompile the code)

0 Answers   Yahoo,

---

How to update a data for the views in the relational data base schema

1 Answers   TCS,

---

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

0 Answers  

---