Exam-style question
Try this first
Which SQL statement inserts a new row into the Product table?.
- A.INSERT INTO Product (ProductID, Name) VALUES (3, 'Keyboard');
- B.ADD Product (ProductID, Name) VALUES (3, 'Keyboard');
- C.UPDATE Product SET (ProductID, Name) VALUES (3, 'Keyboard');
- D.CREATE Product (ProductID, Name) VALUES (3, 'Keyboard');
Model answer
What a good answer should say
- INSERT INTO Product (ProductID, Name) VALUES (3, 'Keyboard');
Explanation
Why this works
INSERT INTO adds a new row. The column list identifies the columns being supplied, and VALUES supplies the corresponding data.
Common mistake
No common mistake is linked to this question yet.