• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Advanced Query Techniques > Using SQL to Update Data

Using SQL to Update Data

SQL can be used not only to retrieve data, but to update it as well. This concept was introduced in the section “Action Queries,” which focused on the SQL statements behind the Action queries.

The UPDATE Statement

The UPDATE statement is used to modify the data in one or more columns of a table. The syntax for the UPDATE statement is


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint