Your question is Truncate vs Delete. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
What is the difference between TRUNCATE and DELETE in SQL?
Asked in the Technical Phone Screen stage. SQL DDL vs DML commands.
| Column | Type | Description |
|---|---|---|
| idPK | INT | Primary key |
| status | VARCHAR(20) | Row status |
| created_at | TIMESTAMP | Row creation timestamp |