Q297
Which of the following is more efficient? LOAD DATA, INSERT
A.
LOAD DATA
AnswerB.
INSERT
C.
Same
D.
Indeterminate
Answer: Option A
Solution
Answer: Option A
Solution:
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.