Interested to Buy Any Domain ? << Click Here >> for more details...
How to load data from a text file into a table?
- 7 Answers
- 15895 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
What is mysql community server?
How do I view tables in mysql workbench?
What is difference between mysql and mariadb?
How to use mysqldump to create a copy of the database?
What is pragma serially_reusable and why is it used?
How MySQL Optimizes DISTINCT?
How many triggers are possible in mysql?
How do I enable mysqli extension?
Can you tell few best practices to be followed for optimization in sql?
How to Change a users password from unix shell.
How to delete a trigger in mysql?
Write a query to create a database and a table?
What is the data source name for mysql?
What are the 5 r's of managing behaviors?
Is mysql a backend?
