Insert the following information: Table: Item Itemno Iname Price Quantity 101 Soap 50 100 102 Powder 100 50 103 Face cream 150 25 104 Pen 50 200 105 Soap box 20 100
Advertisements
Advertisements
Question
Insert the following information:
Table: Item
| Itemno | Iname | Price | Quantity |
|---|---|---|---|
| 101 | Soap | 50 | 100 |
| 102 | Powder | 100 | 50 |
| 103 | Face cream | 150 | 25 |
| 104 | Pen | 50 | 200 |
| 105 | Soap box | 20 | 100 |
Code Writing
Advertisements
Solution
INSERT INTO Item (Itemno, Iname, Price, Quantity) VALUES
(101, 'Soap', 50, 100),
(102, 'Powder', 100, 50),
(103, 'Face cream', 150, 25),
(104, 'Pen', 50, 200),
(105, 'Soap box', 20, 100);shaalaa.com
Is there an error in this question or solution?
