Difference between revisions of "UPDATE"

From braindump
Jump to navigation Jump to search
 
Line 27: Line 27:


== Additional Information ==
== Additional Information ==
* [http://en.wikipedia.org/wiki/Update_%28SQL%29 Wikipedia on SQL UPDATE]
* [http://www.w3schools.com/SQL/sql_update.asp W3Schools on SQL UPDATE]
* [http://www.w3schools.com/SQL/sql_update.asp W3Schools on SQL UPDATE]
* [http://dev.mysql.com/doc/refman/5.0/en/update.html MySQL 5.0 UPDATED documenation]
* [http://dev.mysql.com/doc/refman/5.0/en/update.html MySQL 5.0 UPDATED documenation]

Latest revision as of 02:51, 19 January 2011

{{#set:Related SQL command=INSERT|Related SQL command=DELETE|Related SQL command=SELECT}}

UPDATE is refers to the SQL command UPDATE.

Summary

The UPDATE command is used to update existing records in a table. Syntax may vary between certain types of databases but is generally uniform across multiple vendors.

Syntax

  UPDATE <table> 
    SET <column> = <value> [, <column> = <value>] [, ...]]
    [ WHERE <condition> ]

Examples

To update the value from "foo" to "foobar" in column "bar" in table "baz" do the following:

  INSERT INTO baz ( bar ) VALUES( "foo" )
  UPDATE baz SET bar = "foobar" WHERE bar = "foo" 

Note: This will udpdate all the instances where bar has a value of "foo" to "foobar"

Excersises

  1. Use the sample database and insert and populate it with the data from the [[File::/etc/shadow]].

Additional Information