How to load data from a text file into a table?
Answer Posted / tushar
To load the text file pet.txt into the pet table, use this statement:
mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is an example of a delimiter?
What is max connections in mysql?
What is a join? Explain the different types of mysql joins.
What is a delimiter in mysql?
What is a tinyint?
What are Heap tables?
What is row?
Explain the difference between procedure and function in mysql?
How much does mysql enterprise cost?
How many mysql connections can handle?
Why is the basic difference between left join, right join and inner join?
What is definer in mysql?
What is mysqlcommand?
What is prepare statement in mysql?
How do I free up space in mysql?