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
What is database migration in mysql?
What is database engine in mysql?
Which command is used to view the content of the table in mysql?
How do you rename a table in mysql?
How can we convert between Unix & MySQL timestamps?
What is the datatype of image in mysql?
How do I connect to a mysql database?
Explain the different types of constraints?
Is mysql port 3306 tcp or udp?
How do I optimize a selected query in mysql?
What is pdo :: fetch_assoc?
What is ntext?
What ascii 31?
What is truncate command?
What is the usage of "i-am-a-dummy" flag in mysql?