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 does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
How do I quit mysql?
What is triggers and how it can be used in mysql?
What is a transaction? Describe mysql transaction properties.
How do you rename a table?
Why should I learn mysql?
Explain what is mysql?
How do I change the max connections in mysql?
What are date and time data types?
What does mysql flush hosts do?
How to represent ENUMs and SETs internally?
Can we store images in mysql database?
How do I start mysql in ubuntu?
How many columns can a table have?
Write a query to find duplicate rows in table?