Question: You are loading data into a table. Which command can you use to make sure that all data is inserted and duplicates rows are discarded?
- `INSERT IGNORE`
- `INSERT UNIQUE`
- `INSERT INTO`
- `INSERT DISTINCT`
Answer: The correct answer of the above question is Option A:`INSERT IGNORE`