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

Modifying Data

You use the SQL UPDATE statement to update one or more columns. This usually involves specifying the following:

  • The table containing the data you want to update.

  • The column or columns you want to update, preceded by the SET keyword. If you specify more than one item, each must be separated by a comma.

  • An optional WHERE clause to specify which rows to update. If no WHERE clause is provided, all rows are updated.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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