Hurl.it - Make HTTP requests. FDA Adverse Events Reporting System (FAERS) > FDA Adverse Event Reporting System (FAERS): Latest Quarterly Data Files. Pillbox - National Library of Medicine. Import CSV File Into MySQL Table. This tutorial shows you how to use the LOAD DATA INFILE statement to import CSV file into MySQL table.
The LOAD DATA INFILE statement allows you to read data from a text file and import the file’s data into a database table very fast. Before importing the file, you need to prepare the following: A database table to which the data from the file will be imported.A CSV file with data that matches with the number of columns of the table and the type of data in each column.The account, which connects to the MySQL database server, has FILE and INSERT privileges. Suppose we have a table named discounts with the following structure: