Databases · Junior · Question 33 of 75
Which statement adds a row?
- 1
ADD INTO users VALUES ('Ann'); - 2
UPDATE users ADD ('Ann'); - ✓Correct answer:
INSERT INTO users (name, email) VALUES ('Ann', 'ann@example.com');
Explanation
List the columns explicitly so the statement keeps working if columns are added. PostgreSQL's RETURNING id returns generated values in the same query.