Interested to Buy Any Domain ? << Click Here >> for more details...
How to load data from a text file into a table?
- 7 Answers
- 15352 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 many ways we can retrieve the date in result set of mysql using php?
What is mysql primary key?
Is mysql distributed?
What is difference between pdo and mysqli?
What does mysql flush privileges do?
What are the differences between a primary key and foreign key?
Is mongodb faster than mysql?
What is the maximum no of columns a table can have?
How to control the max size of a heap table?
How many sql dml commands are supported by 'mysql'?
What is use command in mysql?
What is difference between microsoft sql and mysql?
How do I tune a mysql query?
How do I automate a backup in mysql?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
