Which of the following INSERT statements are syntactically correct?

Which of the following INSERT statements are syntactically correct?

Which of the following INSERT statements are syntactically correct?

A.
INSERT INTO friends (id, name, lastname, age) VALUES (1, ‘John’, ‘Doe’, 22)

B.
INSERT INTO friends VALUES (1, ‘John’, ‘Doe’, 22)

C.
INSERT INTO friends ROWS (1, ‘John’, ‘Doe’, 22)

D.
INSERT INTO friends SET id=1, name=’John’, lastname=’Doe’, age=22



Leave a Reply 0

Your email address will not be published. Required fields are marked *