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 can I see connections in mysql?
What are the benefits of mysql?
Can't connect mysql server on localhost?
How to show table names with 'mysqlshow'?
Write command to import an mysql file?
Is microsoft sql same as mysql?
How many rows can a mysql table hold?
How do I insert an image into mysql workbench?
What are the steps required to view your mysql database?
How to enter Characters as HEX Numbers?
What is blob in mysql?
What are aggregate functions in mysql?
Can mysql store files?
What is pragma exception?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.