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

Without LOCAL, LOAD DATA is . . . . . . . .

Answer & Solution
Correct Answer: Option A
This question is about how LOAD DATA works in MySQL.
LOAD DATA is a command that lets you import data into a table from a file.
LOCAL is a keyword you can use with LOAD DATA to tell MySQL to read the file from your local computer.
Without LOCAL, LOAD DATA reads the file from the server where MySQL is running.
So, the answer is Option B: less efficient.
Here's why:
- When you use LOCAL, MySQL can access the data directly from your computer, which is generally faster.
- Without LOCAL, MySQL has to transfer the data from the server, which adds extra time and makes the process slower.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.