well I took the list that is in WMP and put it into the sql file but since each genre is in a specific letter listing I thought that since I have a total of like 127 different genres that I could use a number instead... for instance
I know this isn't correct but I don't know what the line is exactly off the top of my head:
Code: Select all
INSERT INTO genre ('1' , 'Alternative');
but it doesn't work. So my question is do the genre have to be ordered using the alpha system instead of numbers and if so if there a easier way of adding 100+ genres?
Anyone have any ideas? Or atleast steer me in the right direction
any and all help is greatly appreciated....