Entry

Database: Language: SQL: Table: Operation: Change: Update: How to update data in a table?

Mar 20th, 2005 02:39
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 20 March 2005 - 04:23 pm ----------------------

Database: Language: SQL: Table: Operation: Change: Update: How to 
update data in a table?

---

Use the SQL command:

 UPDATE <your table name>

---
---

General format:

-----------------------------------------------
UPDATE
 <mytable>
SET
 <columnname1> = <value1>,
 <columnname2> = <value2>,
 <columnname3> = <value3>,
 ...
 <columnnameN> = <valueN>
WHERE
 <columnnameM> = <valueM>
;
-----------------------------------------------

---
---

-----------------------------------------------
UPDATE
 tableAddressS
SET
 columnFirstNameS = 'Knud'
WHERE
 columnFirstNameS = 'knud'
AND
 columnLastNameS = 'van Eeden'
;
-----------------------------------------------

---
---

Internet: see also:

---

Database: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------