How to import a comma delimited list into a MySQL table

Importing a comma delimited list (any kind of delimited list actually) to a MySQL database is a fairly straight forward process. Using a short SQL query you can easily have your table populated with the delimited list.

What is needed?
Delimited list file - If your data is in a different format like an Excel Spreadsheet, you should first export it as a delimited list.
phpMyAdmin - to make life easier. You can of course run the query from the command line