How can you load large amounts of data from flat-text files?



How can you load large amounts of data from flat-text files?..

Answer / Praveen Shrivastava

Loading large amounts of data from flat-text files can be done using SQL LOAD DATA INFILE or similar commands depending on the database system. Here's an example using MySQL:n```sqlnLOAD DATA INFILE '/path/to/file.csv' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '"';n```

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Software Interview Questions

How can you determine if a ray intersects a sphere? The more efficient your solution, the better.

1 Answers  


what is FORMAT keyword

1 Answers  


How to ignore some file in mvc

1 Answers   Chetu India,


what are the advantages of PO 7.4 version ? new features in it ?

1 Answers   IBM,


What is the movement Type for Sales?

1 Answers  


There were 100members who are standing in circle form with numbered on them like 1, 2,3 upto 100. If number 1 has a knife and killed the next one right behind him and give it number 3 likewise it contines upto 100.Then who will be left if this process repeated?

5 Answers   Zoho,


Do you know the S/4 HANA?

1 Answers  


How to Monitor the Batch Jobs?

1 Answers  


What is the difference between raster and vector graphics?

1 Answers  


Whay $ dropdb databasename is used?

1 Answers  


How Accounting determination happened?

1 Answers  


HOW to click on elements under moving banner, in selenium webdriver

1 Answers  


Categories