PHPMYADMIN import from local file

Again, this is really a note to myself, but here is a query to import CSV data on the server: -

LOAD DATA LOCAL INFILE '' INTO TABLE `` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES

N.B. You have to make sure the structure is already in place.

Get in touch

4 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

This form collects your name, telephone number (optionally) and email address only so we can contact you back about your enquiry. We do not and will never use your data for any other purposes other than contacting you regarding this enquiry and no data is shared with any third-party.