ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which of the following is more efficient?
LOAD DATA, INSERT

Answer & Solution
Correct Answer: Option A
This question asks about the efficiency of two ways to add data to a MySQL table: LOAD DATA and INSERT.

LOAD DATA is designed for importing large amounts of data from a file. It's like copying and pasting data directly into the table, making it very fast.

INSERT is used for adding data row-by-row. While it works for smaller datasets, it can be slower for large imports.

Therefore, the answer is Option A: LOAD DATA

LOAD DATA is generally more efficient for importing large amounts of data.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.