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,
- Change the price of Geranium seeds to £20.
- Increase the price of all seeds by 10% (price = price *1.1).
- Change the seed type of all Hardy Perennials to Well-Hardy Perennials.
- Consider how silly a thing that was to do and change them back.