How to load data from a text file into a table?
- 7 Answers
- 14459 Views
- Sasaa, I also Faced
- E-Mail Answers
Answer Posted / palanisamy
we have the mysql query which will load csv file into db
syntax:
load data infile 'pathtothefile' into table name
line termineted by '\n',
field teminated by ',';
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Can I install mysql on mac?
What is a mysql view?
What is the maximum no of columns a table can have?
What's the latest version of mysql?
What do you need to connect php to mysql?
What are the advantages and disadvantages of using mysql?
How can I connect mysql database?
What is mysql used for?
How to see table's field formats or description of table .
What is mysql default database?
How to rename an existing column in a table?
How to create a table?
What is the difference between the primary and unique key in mysql?
What is mysql and how it works?
How to load a csv file into a table
