MySQL Insert Into Table | Dataford Interview Questions

How would you write an SQL insert statement to add rows into a table?

Write a PostgreSQL statement that adds three project assignment records to the project_assignments table. The statement should return the rows that were inserted.

Output

One row per inserted assignment.
Columns: assignment_id, engineer_name, specialty, start_date, and active.
Order rows by assignment_id ascending.

Schema

project_assignments

Column	Type	Description
assignment_idPK	INT	Unique project assignment identifier
engineer_name	VARCHAR(100)	Name of the assigned engineer
specialty	VARCHAR(100)	Engineering specialty
start_date	DATE	Assignment start date
active	BOOLEAN	Whether the assignment is currently active

Your question is MySQL Insert Into Table. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem