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 flush privileges in mysql?
What is mysql_connect?
How do you create a schema?
How can you take the backup and restore a mysql database using php?
How can I see connections in mysql?
can you elaborate on blob and text in mysql? : Mysql dba
What is dbms in mysql?
Does mysql automatically index foreign keys?
How to insert html code into mysql database using php?
How many sql ddl commands are supported by 'mysql'?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
Does mysql scale well?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
How to run a sql statement?
How to display nth highest salary from a table in a mysql query?