📄 db_musicsky.sql
字号:
VALUES ('0-003-0101','Pop', '放假了', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0102','Pop', '精灵', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0103','Pop', '一个人长大', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0104','Pop', '考试中', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0105','Pop', '梦游记', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0106','Pop', '妈妈我爱你', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0107','Pop', '青蛙公主', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0108','Pop', '酸酸甜甜就是我', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0109','Pop', '星期天', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('0-003-0110','Pop', '想唱就唱', '我很张含韵 (正式版)', '张含韵','天中文化' ,'2005年07月' ,2 ,'国语')
/* 插入歌曲数据：李贞贤_I Love Natural */
raiserror(' 插入歌曲数据：李贞贤_I Love Natural ....',0,1)
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0201','Pop','丹心歌', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0202','Pop','月亮啊月亮', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0203','Pop','Q', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0204','Pop','Tell Me', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0205','Pop','Time Machine', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0206','Pop','故乡之春', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0207','Pop','Brighter Than Sunshine', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0208','Pop','Rhythm Nature', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0209','Pop','ariari(阿里阿里)', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0210','Pop','还祈求什么？', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0211','Pop','可恨', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0212','Pop','看我', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0213','Pop','Belive', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0214','Pop','Sun Flower', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,2 ,'')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-001-0215','Pop','To Be Continued', 'I Love Natural', '李贞贤','Yedang Entertainment Company (KR)' ,'2002年' ,1 ,'')
/* 插入歌曲数据：李孝利_Lee Hyo Lee vol.1 */
raiserror(' 插入歌曲数据：李孝利_Lee Hyo Lee vol.1 ....',0,1)
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0101','Pop','Prologue(Drum&Bass)', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0102','Pop','One two three N’four', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0103','Pop','像傻瓜一样(Sadness)', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0104','Pop','10 MINUTES', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0105','Pop','冰', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0106','Pop','夏娃,睡在伊甸园', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0107','Pop','Remember Me', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0108','Pop','就今天', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0109','Pop','Do Me', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0110','Pop','Hey Girl', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0111','Pop','擦去', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0112','Pop','某个Jazz Bar', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0113','Pop','Only One', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
INSERT INTO musicinfo (SongId, Category, Title, CdName, ArtistName, Publisher, PUBLISH_DATE, Price, Language)
VALUES ('1-101-0114','Pop','对不起(Ghost)', 'Lee Hyo Lee vol.1', '李孝利','Daeyoung AV' ,'2003年9月' ,2 ,'韩语')
/* 插入歌词的数据 */
raiserror('
插入所有歌词数据(表lyric) ....',0,1)
INSERT INTO lyric (SongId, Title, ArtistName, CdName, Lyric)
VALUES ('0-001-0701', '夜曲', '周杰伦', '十一月的肖邦', '
一群嗜血的蚂蚁被腐肉所吸引
<BR>我面无表情看孤独的风景
<BR>失去你爱开始分明
<BR>失去你还有什么事好关心
<BR>那鸽子不再象征和平
<BR>我终于被提醒捆着手我现在是奴隶
<BR>我用漂亮的押韵形容被掠夺一空的爱情
<BR>我应该藏这里夜色不干净
<BR>还给你整夜的回忆占满天的星
<BR>送你的白色玫瑰在纯黑的花季凋零
<BR>午夜在树枝上诡异的很安静
<BR>倾听我黑色的大衣像我的你
<BR>衣栉比鳞的鬼走过的走过的生命
<BR>啊四周弥漫雾气
<BR>啊我在空旷的墓地
<BR>老去后还爱你
<BR>为你弹奏肖邦的夜曲
<BR>纪念我死去的爱情
<BR>跟夜风一样的声音
<BR>心碎的很好听
<BR>手在键盘敲钢琴
<BR>我给的思念太小心
<BR>你埋葬的地方叫幽灵
<BR>为你弹奏肖邦的夜曲
<BR>纪念我死去的爱情
<BR>而我为你隐姓埋名
<BR>在月光下弹琴
<BR>对你心跳的感应
<BR>还是如此温热亲近
<BR>怀念你那鲜红的唇印
<BR>那些断翅的蜻蜓散落在这森林
<BR>而我的眼睛没有丝毫同情
<BR>失去你泪水混浊无情
<BR>失去你我连笑容都有阴影
<BR>我站在满心期待的屋顶
<BR>嘲笑我的伤心
<BR>像一口没有水的枯井
<BR>我用尽我的自信
<BR>要我后悔莫急等待爱情
<BR>为你弹奏肖邦的夜曲
<BR>纪念我死去的爱情
<BR>跟夜风一样的声音
<BR>心碎的很好听
<BR>手在键盘敲钢琴
<BR>我给的思念太小心
<BR>你埋葬的地方就有你
<BR>为你弹奏肖邦的夜曲
<BR>纪念我死去的爱情
<BR>而我为你隐姓埋名
<BR>在月光下弹琴
<BR>对你心跳的感应
<BR>还是如此温热亲近
<BR>怀念你那鲜红的唇印
<BR>一群嗜血的蚂蚁被腐肉所吸引
<BR>我面无表情看孤独的风景
<BR>失去你爱开始分明
<BR>失去你还有什么事好关心
<BR>那鸽子不再象征和平
<BR>我终于被提醒捆着手我现在是奴隶
<BR>我用漂亮的押韵形容被掠夺一空的爱情
')
INSERT INTO lyric (SongId, Title, ArtistName, CdName, Lyric)
VALUES ('0-001-0702', '蓝色风暴', '周杰伦', '十一月的肖邦', '
亘古长夜 善恶交接
<BR>我终于懂得流眼泪
<BR>洪荒世界 百分之七十都是水
<BR>湛蓝的 旷野
<BR>在海平面渴望满月
<BR>于是我终于学会告解
<BR>弥赛亚被世人误解 被分类
<BR>爱恨 从此敌对
<BR>远离风暴浩劫
<BR>在第三章第四节
<BR>我正在改写这世界
<BR>用观念进行侵略
<BR>我们占领整条街
<BR>粉刷海洋蓝的季节
<BR>一列 超高速的地铁
<BR>一路 训练我的听觉
<BR>消灭 那些 太琐碎 太异类
<BR>让问题尖锐 Oh ~
<BR>一双 狂奔中的球鞋
<BR>一路 强壮着我的肺
<BR>面对 这些 太威胁 太强烈
<BR>从来不喊累
<BR>九星联结 排成一列
<BR>在感动中我们忏悔
<BR>生命珍贵
<BR>我用那十四行诗赞美 年轻的一切
<BR>我们在地平线感谢
<BR>爱停止向另一边倾斜
<BR>这首部曲的管弦乐 太凄美
<BR>终于 被人了解
<BR>远离风暴浩劫
<BR>耍狠不是靠对嘴
<BR>我就是传说中的谁
<BR>你跟我们很对味
<BR>有同一挂的感觉
<BR>其它人我根本不屑
<BR>一列 超高速的地铁
<BR>一路 训练我的听觉
<BR>消灭 那些 太琐碎 太异类
<BR>让问题尖锐 Oh ~
<BR>一双 狂奔中的球鞋
<BR>一路 强壮着我的肺
<BR>面对 这些 太威胁 太强烈
<BR>从来不喊累 Oh
')
INSERT INTO lyric (SongId, Title, ArtistName, CdName, Lyric)
VALUES ('0-001-0703', '发如雪', '周杰伦', '十一月的肖邦', '
狼牙月伊人憔悴我举杯饮尽了风雪
<BR>是谁打翻前世柜惹尘埃是非
<BR>
<BR>缘字诀几番轮回你锁眉哭红颜唤不回
<BR>纵然青史已经成灰我爱不灭
<BR>
<BR>繁华如三千东流水
<BR>我只取一瓢爱了解只恋你化身的蝶
<BR>
<BR>你发如雪凄美了离别我焚香感动了谁
<BR>邀明月让回忆皎洁爱在月光下完美
<BR>
<BR>你发如雪纷飞了眼泪我等待苍老了谁
<BR>红尘醉微醺的岁月我用无悔刻永世爱你的碑
<BR>
<BR>rap:
<BR>你发如雪凄美了离别我焚香感动了谁
<BR>邀明月让回忆皎洁爱在月光下完美
<BR>
<BR>你发如雪纷飞了眼泪
<BR>我等待苍老了谁红尘醉微醺的岁月
<BR>
<BR>啦儿啦啦儿啦啦儿啦儿啦啦儿啦啦儿啦啦儿啦儿啦
<BR>
<BR>铜镜映无邪扎马尾你若撒野今生我把酒奉陪
')
INSERT INTO lyric (SongId, Title, ArtistName, CdName, Lyric)
VALUES ('0-001-0704', '黑色毛衣', '周杰伦', '十一月的肖邦', '
一件黑色毛衣
<BR>两个人的回忆
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -