Q
Which statement correctly inserts a row into the EMP table?
-
A
INSERT INTO emp (id, name) VALUES (1, 'Ali');
-
B
INSERT emp VALUES INTO (1, 'Ali');
-
C
ADD INTO emp (id, name) VALUES (1, 'Ali');
-
D
INSERT INTO emp SET id = 1, name = 'Ali';
Correct Answer:
A. INSERT INTO emp (id, name) VALUES (1, 'Ali');
Explanation:
The correct form is INSERT INTO table (columns) VALUES (values). SET syntax is MySQL-specific.
