Describe the format for the UPDATE command.
What will be an ideal response?
The format for the UPDATE command is the word UPDATE, followed by the name of the table to be updated. The next portion of the command consists of the word SET, followed by the name of the column to be updated, an equals sign, and the new value. When necessary, include a WHERE clause to indicate the row(s) on which the change is to take place.
Computer Science & Information Technology
You might also like to view...
Base creates and adds a primary key by default
Indicate whether the statement is true or false
Computer Science & Information Technology
The default information contained in the Report Header is the column headers, which are taken from the captions from the table design. If no captions were defined, the values are field names
Indicate whether the statement is true or false
Computer Science & Information Technology