- 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 40 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 com
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
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
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