Faqts : Computers : Programming : Languages : Sql

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

2 of 3 people (67%) answered Yes
Recently 2 of 3 people (67%) answered Yes

Entry

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

Aug 27th, 2009 00:56
techi gity, 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
----------------------------------------------------------------------
http://blogtact.com/
http://uddannelsepainternet.blogtact.com/
http://anxietygk.blogtact.com/
http://insuranceru.blogtact.com/
http://ajandekotlet.blogtact.com/
http://reisenenglandschottland.blogtact.com/
http://voyageangleterreecosse.blogtact.com/
http://travelengscoru.blogtact.com/
http://voyageafrique.blogtact.com/
http://automobilecommentaires.blogtact.com/
http://geschenkeidee.blogtact.com/
http://itavaltahotellit.blogtact.com/
http://petsru.blogtact.com/
http://insurancebg.blogtact.com/
http://haziallatellatas.blogtact.com/
http://landerderwelt.blogtact.com/
http://europetravelru.blogtact.com/
http://flyvninger.blogtact.com/
http://geschenkideeen.blogtact.com/