How to load data from a text file into a table?
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 do I download a mysql community server?
How many tables we can create in mysql database?
What is mysql procedure?
What is horizontally scalable?
How to execute mysql query in php?
What is view in mysql?
How to load data files into tables with 'mysqlimport'?
Where is the mysql database stored?
Is mysql a programming language?
What is the innodb in mysql?
How to change a password for an existing user via mysqladmin?
What is mysql slow query?
What are the differences between binary and varbinary?
What is the difference between b-tree and hash indexes?
Why mongodb is faster than mysql?