Structured Query Language
Update Queries

Update queries are used to change the data in the table. You can change one row at a time or lots of rows depending on how you write the WHERE clause of your query. The following query will change the price of Acacia seeds to £9.

UPDATE tblseeds SET price = '9.00' WHERE name = 'Acacia';

Write queries to do the following,

  1. Change the price of Geranium seeds to £20.
  2. Increase the price of all seeds by 10% (price = price *1.1).
  3. Change the seed type of all Hardy Perennials to Well-Hardy Perennials.
  4. Consider how silly a thing that was to do and change them back.