music.sql

1、上传所有文件至服务器目录。 2、使用 MYSQL 管理工具

INSERT INTO music_musiclist VALUES('51375', 'new/20037/63/04.wma', 'Happy Birthday (伴奏)', 'Twins', '1', '3', '187', '28', '4213', '0');
INSERT INTO music_musiclist VALUES('51376', 'new/20037/63/05.wma', 'Hello，How Do You Do (伴奏)', 'Twins', '1', '3', '187', '31', '4213', '0');
INSERT INTO music_musiclist VALUES('51377', 'new/20037/63/06.wma', 'Long Long Ago (伴奏)', 'Twins', '1', '3', '187', '31', '4213', '0');
INSERT INTO music_musiclist VALUES('51378', 'new/20037/63/07.wma', 'Jingle Bells (伴奏)', 'Twins', '1', '3', '187', '27', '4213', '0');
INSERT INTO music_musiclist VALUES('51379', 'new/20037/63/08.wma', 'The Farmer In The Dell (伴奏)', 'Twins', '1', '3', '187', '28', '4213', '0');
INSERT INTO music_musiclist VALUES('51380', 'new/20037/63/09.wma', 'Ten Little Inidan Boys (伴奏)', 'Twins', '1', '3', '187', '26', '4213', '0');
INSERT INTO music_musiclist VALUES('51381', 'new/20037/63/10.wma', 'The Muffin Man (伴奏)', 'Twins', '1', '3', '187', '27', '4213', '0');
INSERT INTO music_musiclist VALUES('51382', 'new/20037/63/11.wma', 'A For Apple B For Boy (伴奏)', 'Twins', '1', '3', '187', '26', '4213', '0');
INSERT INTO music_musiclist VALUES('51383', 'new/20037/63/12.wma', 'Five Little Ducks (伴奏)', 'Twins', '1', '3', '187', '25', '4213', '0');
INSERT INTO music_musiclist VALUES('51384', 'new/20037/63/13.wma', 'I Went To School One Morning (伴奏)', 'Twins', '1', '3', '187', '26', '4213', '0');
INSERT INTO music_musiclist VALUES('51385', 'new/20037/63/14.wma', 'This Old Man (伴奏)', 'Twins', '1', '3', '187', '27', '4213', '0');
INSERT INTO music_musiclist VALUES('51386', 'new/20037/63/15.wma', 'Red River Valley (伴奏)', 'Twins', '1', '3', '187', '26', '4213', '0');
INSERT INTO music_musiclist VALUES('51387', 'new/20037/63/16.wma', 'Skip To My Lou (伴奏)', 'Twins', '1', '3', '187', '25', '4213', '0');
INSERT INTO music_musiclist VALUES('51388', 'new/20037/63/17.wma', 'The Mulberry Bush (伴奏)', 'Twins', '1', '3', '187', '26', '4213', '0');
INSERT INTO music_musiclist VALUES('51389', 'new/20037/63/18.wma', 'This Is The Way (伴奏)', 'Twins', '1', '3', '187', '28', '4213', '0');
INSERT INTO music_musiclist VALUES('51390', 'new/20037/63/19.wma', 'You\'re My Sunshine (伴奏)', 'Twins', '1', '3', '187', '26', '4213', '0');
INSERT INTO music_musiclist VALUES('51391', 'new/20037/63/20.wma', 'London Bridge Is Falling Down (伴奏)', 'Twins', '1', '3', '187', '27', '4213', '0');
INSERT INTO music_musiclist VALUES('51392', 'new/20037/64/01.wma', '爱像', '红苹果乐园', '1', '4', '2151', '170', '4214', '0');
INSERT INTO music_musiclist VALUES('51393', 'new/20037/64/02.wma', '暗', '红苹果乐园', '1', '4', '2151', '154', '4214', '0');
INSERT INTO music_musiclist VALUES('51394', 'new/20037/64/03.wma', '动感', '红苹果乐园', '1', '4', '2151', '81', '4214', '0');
INSERT INTO music_musiclist VALUES('51395', 'new/20037/64/04.wma', '范姜太太的', '红苹果乐园', '1', '4', '2151', '64', '4214', '0');
INSERT INTO music_musiclist VALUES('51396', 'new/20037/64/05.wma', '红苹果', '红苹果乐园', '1', '4', '2151', '147', '4214', '0');
INSERT INTO music_musiclist VALUES('51397', 'new/20037/64/06.wma', '红苹果乐园', '红苹果乐园', '1', '4', '2151', '160', '4214', '0');
INSERT INTO music_musiclist VALUES('51398', 'new/20037/64/07.wma', '红苹果乐园(卡拉OK版)', '红苹果乐园', '1', '4', '2151', '111', '4214', '0');
INSERT INTO music_musiclist VALUES('51399', 'new/20037/64/08.wma', '就这样', '红苹果乐园', '1', '4', '2151', '113', '4214', '0');
INSERT INTO music_musiclist VALUES('51400', 'new/20037/64/09.wma', '快', '红苹果乐园', '1', '4', '2151', '66', '4214', '0');
INSERT INTO music_musiclist VALUES('51401', 'new/20037/64/10.wma', '狂爱音乐', '红苹果乐园', '1', '4', '2151', '73', '4214', '0');
INSERT INTO music_musiclist VALUES('51402', 'new/20037/64/11.wma', '你', '红苹果乐园', '1', '4', '2151', '62', '4214', '0');
INSERT INTO music_musiclist VALUES('51403', 'new/20037/65/01.wma', '漂亮宝贝', '红苹果乐园', '1', '4', '2151', '220', '4215', '0');
INSERT INTO music_musiclist VALUES('51404', 'new/20037/65/02.wma', '平常的', '红苹果乐园', '1', '4', '2151', '147', '4215', '0');
INSERT INTO music_musiclist VALUES('51405', 'new/20037/65/03.wma', '伤感', '红苹果乐园', '1', '4', '2151', '99', '4215', '0');
INSERT INTO music_musiclist VALUES('51406', 'new/20037/65/04.wma', '上班族', '红苹果乐园', '1', '4', '2151', '97', '4215', '0');
INSERT INTO music_musiclist VALUES('51407', 'new/20037/65/05.wma', '痛', '红苹果乐园', '1', '4', '2151', '91', '4215', '0');
INSERT INTO music_musiclist VALUES('51408', 'new/20037/65/06.wma', '幸', '红苹果乐园', '1', '4', '2151', '78', '4215', '0');
INSERT INTO music_musiclist VALUES('51409', 'new/20037/65/07.wma', '幸福', '红苹果乐园', '1', '4', '2151', '111', '4215', '0');
INSERT INTO music_musiclist VALUES('51410', 'new/20037/65/08.wma', '幸福的', '红苹果乐园', '1', '4', '2151', '90', '4215', '0');
INSERT INTO music_musiclist VALUES('51411', 'new/20037/65/09.wma', '寻找真爱', '红苹果乐园', '1', '4', '2151', '92', '4215', '0');
INSERT INTO music_musiclist VALUES('51412', 'new/20037/65/10.wma', '幽默诙谐', '红苹果乐园', '1', '4', '2151', '70', '4215', '0');
INSERT INTO music_musiclist VALUES('51413', 'new/20037/65/11.wma', '运动天', '红苹果乐园', '1', '4', '2151', '71', '4215', '0');



DROP TABLE IF EXISTS music_nclass;
CREATE TABLE music_nclass (
   NClassID int(10) unsigned NOT NULL auto_increment,
   NClassName varchar(50) NOT NULL,
   ClassID int(10) unsigned NOT NULL,
   SClassID int(10) unsigned NOT NULL,
   NameCode char(1) NOT NULL,
   PRIMARY KEY (NClassID)
);

INSERT INTO music_nclass VALUES('127', '黄品源[Huang, Pin Yuan]', '1', '1', 'H');
INSERT INTO music_nclass VALUES('176', '萧亚轩', '1', '2', 'X');
INSERT INTO music_nclass VALUES('187', 'Twins', '1', '3', 'T');
INSERT INTO music_nclass VALUES('1335', '黄耀明[Wong, Yiu Ming Anthony]', '1', '1', 'H');
INSERT INTO music_nclass VALUES('2149', 'Modern Love', '1', '4', 'M');
INSERT INTO music_nclass VALUES('2150', '林佑威', '1', '1', 'L');
INSERT INTO music_nclass VALUES('2151', '红苹果乐园', '1', '4', 'H');



DROP TABLE IF EXISTS music_sclass;
CREATE TABLE music_sclass (
   SClassID int(10) unsigned NOT NULL auto_increment,
   SClassName varchar(50) NOT NULL,
   ClassID int(10) unsigned NOT NULL,
   PRIMARY KEY (SClassID)
);

INSERT INTO music_sclass VALUES('1', '华人男歌手', '1');
INSERT INTO music_sclass VALUES('2', '华人女歌手', '1');
INSERT INTO music_sclass VALUES('3', '华人组合', '1');
INSERT INTO music_sclass VALUES('4', '影视杂锦', '1');
INSERT INTO music_sclass VALUES('5', '日韩男歌手', '1');
INSERT INTO music_sclass VALUES('6', '日韩女歌手', '1');
INSERT INTO music_sclass VALUES('7', '日韩组合', '1');
INSERT INTO music_sclass VALUES('9', '欧美歌手', '1');
INSERT INTO music_sclass VALUES('10', '闽南语台语', '1');
INSERT INTO music_sclass VALUES('11', '儿童歌曲', '1');
INSERT INTO music_sclass VALUES('12', '音乐欣赏', '1');
INSERT INTO music_sclass VALUES('13', 'DJ摇滚', '1');
INSERT INTO music_sclass VALUES('14', '怀旧珍藏', '1');