Answer Posted / rajesh venati

It is also work,

UPDATE TABLE_NAME SET COL_NAME=NEW_VALUE WHERE
COL_NAME=OLD_VALUE;

EX:-

SQL> SELECT * FROM RAJ;

EMPNO
----------
100
200
300
4

SQL> UPDATE RAJ SET EMPNO=400 WHERE EMPNO=4;

1 row updated.

SQL> SELECT * FROM RAJ;

EMPNO
----------
100
200
300
400

what are date and time data types? : Sql dba

539

---

discuss about myisam key cache. : Sql dba

563

---

How many clustered indexes can be created on a table?

591

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1710

---

what tools available for managing mysql server? : Sql dba

533

---

---

How do I view a table in sql?

545

---

What is character functions?

558

---

What are the usages of sql?

564

---

What is native sql query?

552

---

What is union and union all keyword in sql and what are their differences?

577

---

Explain normalization and what are the advantages of it?

518

---

What are sql functions? Describe in brief different types of sql functions?

487

---

Does view contain data?

618

---

what is 'mysqlcheck'? : Sql dba

574

---

What are the indexing methods?

575

---