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


Please Help Members By Posting Answers For Below Questions

What is an example of a delimiter?

696


What is max connections in mysql?

691


What is a join? Explain the different types of mysql joins.

1006


What is a delimiter in mysql?

695


What is a tinyint?

715


What are Heap tables?

1145


What is row?

766


Explain the difference between procedure and function in mysql?

740


How much does mysql enterprise cost?

687


How many mysql connections can handle?

668


Why is the basic difference between left join, right join and inner join?

751


What is definer in mysql?

727


What is mysqlcommand?

685


What is prepare statement in mysql?

732


How do I free up space in mysql?

681