I have a text file that contains a music genre on each line, as follows:
( there are lots more )
I need to import these genres into my database, which is simply structured as follows:
id int auto increment
genre_name varchar 255
How can insert all the genres from the txt file using either a MySQL query, or using a php script?
I certainly don't want to have to do this manually using PhpMyAdmin, ya know!