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

Part V: Appendix > Modifying with SQL UPDATE

Modifying with SQL UPDATE

A SQL UPDATE statement is the same as the update query executed by the Access user interface to modify existing data. This statement uses the following syntax:

UPDATE datasource
SET col1 = expression[, col2 = expression, ...]
[WHERE condition]


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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