?
Which of the following is more efficient?
Which of the following is more efficient?
LOAD DATA, INSERT
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.
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.
Join the Discussion
Login to post a comment or share your explanation.
Login