Filter
Top Products
3.2 Updating data in a Data Base
Use the UPDATE statement to update data in a table. The following is an example of the UPDATE statement:
Example:
In this example, ORDERQTY is updated to "50" for the data for PRODNO "215" and CUSTOMER "61"
in the ORDER table.
This section explains the following operations that can be performed by the UPDATE statement:
· Updating values in multiple columns
· Specifying a null value for data to be updated
· Using default values in data to be updated
· Specifying the current date and time in data to be updated
· Using values from other columns in data to be updated
· Performing arithmetic operations on data to be updated
· Updating all rows in a table
29