Page 1 of 1
11. The price of a food item in our database has increased from £2 to £2.50. The food item has an id of 21. What SQL com
Posted: Sun Jul 10, 2022 11:23 am
by answerhappygod
- 11 The Price Of A Food Item In Our Database Has Increased From 2 To 2 50 The Food Item Has An Id Of 21 What Sql Com 1 (16.71 KiB) Viewed 42 times
11. The price of a food item in our database has increased from £2 to £2.50. The food item has an id of 21. What SQL command do we need to make the change in the database? UPDATE price SET VALUE=2.50 WHERE id=21 UPDATE dishes SET price=2.50 WHERE id=21 UPDATE dishes SET price="2.00" WHERE id=21 SELECT price FROM dishes WHERE id=21