Tag Archives: php

Recently I needed to bring a spreadsheet of data into a MySQL database table using the phpMyAdmin web front-end. It had been a while since I had last done this, and some of the import screen’s options didn’t seem to make sense. Why was the default value separator a semicolon? Was there something I had forgotten about the CSV file format? Time for some research. I found very little useful information online, and decided to muddle through it and document the process for the next time it comes up. Here goes.