How to load data from a text file into a table?
- 7 Answers
- 14397 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
How can I compare two mysql databases?
How many rows can mysql hold?
What is a result set object?
What is a delimiter in mysql?
Tell us something about heap tables?
What is pdo :: fetch_assoc?
How large can a mysql table be?
What is row level locking in access?
How many concurrent queries can mysql handle?
What is identity in mysql?
How can I see connections in mysql?
What is the function of mysqldump?
How do I fix a crashed mysql database?
How do I view tables in mysql workbench?
How can we convert between Unix & MySQL timestamps?
