Question: Which statement can you use to load data from a file into the table?

1. cat file|mysql
2. load data infile (correct if the file is already on the server)
3. load data local infile (also correct but only if the file is from the client)
4. extended insert statement

Answer: The correct answer of the above question is Option B:load data infile (correct if the file is already on the server)