Vidyalelo
MySQL · Q297

MySQL

Programming · MySQL · question 297

Q297

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

A.
LOAD DATA
Answer
B.
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.