In this article, you will understand how to import .csv files in the database from phpMyAdmin.<\/p>\r\n
To import a .csv file into a database using phpMyAdmin, save your Excel file as a CSV instead of a workbook. Open it in Notepad to ensure columns are separated by commas (,). Remove column headings, blank areas, and make sure each row and column contains data. The number of columns in the CSV file must match the database table.<\/p>\r\n\r\n\r\n\r\n
LOAD DATA LOCAL INFILE 'Full path to .CSV file'
INTO TABLE city
FIELDS TERMINATED BY ','
ENCLOSED BY '\"'
LINES TERMINATED BY '\\n';<\/pre>\r\nReplace actual full path with “Full path for .CSV file” (\/home\/username\/public_html\/filename.csv)<\/li>\r\n
With the help of above steps you can import .csv file into your database using phpMyAdmin.\u00a0<\/p>\r\n","protected":false},"excerpt":{"rendered":"
In this article, you will understand how to import .csv files in the database from phpMyAdmin. To import a .csv file into a database using phpMyAdmin, save your Excel file…<\/p>\n