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
Can we use mysql and mysqli together?
What is a left join mysql?
What is the full form of mysql?
how to Return total number of rows.
What is unsigned int in mysql?
How do I insert multiple rows in a table?
Can you tell the difference between ereg_replace() and eregi_replace()?
What is session variable 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
Write a query to display current date and time?
How do I fix a crashed mysql database?
How to set mysql variable in php?
Write a query to create a database and a table?
What storage engines are used in MySQL?
How do I truncate all tables in mysql?