Home Online Database ERD Activity 2 Activity 3 Activity 4 Activity 5 Activity 6 Activity 7

Activity 5: Updating existing data/records.

Investigate

First start by learning about the SQL UPDATE statement by reading through the following web page:

Practice

Use the Online Database to perform the following queries:

DescriptionSQL QueryResults
The shipping company "Speedy Express" has a new phone number: (503) 556-4592. Update the relevant record accordingly.
"The Big Cheese" (Customer table) has moved offices. Their new address is 4 Wheels Drive, Dallas, 92302, USA. Update the relevant record accordingly.
Update all products which are less than £20, to increase their price by £1.00