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
Why we use mongodb instead of mysql?
What is the difference between BLOB AND TEXT?
Is oracle mysql free?
What is meant by mysqli?
Why do we use preparedstatement?
What are the other commands to know the structure of a table using mysql commands except explain command?
How do you login to MySql using Unix shell?
What are the 'mysql' command line arguments?
How do I optimize a selected query in mysql?
What is the default port of mysql server?
How to shut down the server with 'mysqladmin'?
Is mysql free software?
What you can use regular expression for in mysql? Support your answer with an example?
What is 'mysqlshow'?
Is there a free version of mysql?