清风细雨楼 Design By www.eepep.com
su - mysql -c “mysqld_safe –skip-name-resolve –open-files-limit=4096&”
cd /usr/local/mysql/bin/
mysqldump -u用户名 -p密码 –databases 库名 >/backdata/ddd07-11-15.sql
mysqldump –databases zt >/data/ok1.sql
cd /usr/local/mysql/bin/
mysql -uroot -pueoadir zt</backdata/kb.sql
mysqldump -uroot -pueoadir –databases zt >/backdata/back1210.sql
su - mysql -c “mysqld_safe –skip-name-resolve –open-files-limit=4096&”
cd /usr/local/mysql/bin/
mysql -uroot -pueoadir zt4</backdata/new.sql
mysql -uroot -pueoadir zt</data/ok.sql
UE处理下负区导入的表
mysql FLServer</data/FLServer.sql
mysql GMTool</data/GMTool.sql
mysql LoginServer</data/LoginServer.sql
mysql roleChangeServer</data/roleChangeServer.sql
mysql roleregServer</data/roleregServer.sql
mysql unify00</data/unify00.sql
mysql FLServer</data/FLServer.sql
mysql GMTool</data/GMTool.sql
mysql LoginServer</data/LoginServer.sql
mysql roleChangeServer</data/roleChangeServer.sql
mysql roleregServer</data/roleregServer.sql
mysql unify00</data/unify00.sql
mysql FLServer</data/FLServer.sql
mysql zt</data/zt501.sql
mysql -uroot -pueoadir zt</backdata/kb.sql
查询
select * from zt4.CHARBASE where name in (select name from zt.zHARBASE)
select * from CHARBASE limit 100
select UNIONID from CHARBASE limit 100
更新
update zt4.CHARBASE set name=CONCAT('一区',rtrim(name)) where name in (select name from zt.CHARBASE) ‘处理重名
update CHARBASE set name=CONCAT(rtrim(name),'1q')
update CHARBASE set CHARID=CHARID+10
插入
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
insert into game.user(name,pass) select name,pass from game2.user2
导入
mysql -uroot -pueoadir zt</backdata/zt2q.sql
mysql -uroot -pueoadir zt</backdata/1q.sql
删除
delete from CHARBASE WHERE ROUND=0 AND LEVEL < 80 and `LASTACTIVEDATE`< ‘2007-11-19 00:00:00′
delete from CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-19 00:00:00′
1.删除玩家离线时间超过五天且在线时间小于1小时的玩家!
delete from zt.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-12-10 00:00:00′
delete from zt.CHARBASE WHERE ROUND=0 AND LEVEL<80 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
2.去除GM CHARID编号重复
SELECT max(CHARID) FROM `CHARBASE`
update zt4.CHARBASE set CHARID=CHARID+10000 where CHARID < 100 LIMIT 50
update zt4.CHARBASE set CHARID=CHARID+20000 where CHARID in (select CHARID from zt.CHARBASE)
3.去除人物重名
update zt4.CHARBASE set name=CONCAT(rtrim(name),'o') where name in (select name from zt.CHARBASE)
4.插入表2数据到表1
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
________________________________________________
delete from zt4.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt4.CHARBASE WHERE ROUND=0 AND LEVEL<96 and `LASTACTIVEDATE`< ‘2007-12-10 00:00:00′
SELECT max(CHARID) FROM zt4.CHARBASE
select * from zt4.CHARBASE limit 100
update zt4.CHARBASE set CHARID=CHARID+10000 where CHARID in (select CHARID from zt.CHARBASE)
update zt4.CHARBASE set name=CONCAT(rtrim(name),'oo') where name in (select name from zt.CHARBASE)
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
___________________________________________________________________________________
1.删除玩家离线时间超过五天且在线时间小于1小时的玩家!
delete from zt.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt4.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt.CHARBASE WHERE ROUND=0 AND LEVEL<80 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt4.CHARBASE WHERE ROUND=0 AND LEVEL<80 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
2.CHARBASE表里CHARID处理重复 重复ID 前加10000
update zt4.CHARBASE set zt4.CHARBASE.CHARID=zt4.CHARBASE.CHARID+10000 where zt4.CHARBASE.CHARID in (select CHARID from zt.CHARBASE)
CARTOONPET表里CARTOONID与主库CARTOONPET重复的处理
update zt4.CARTOONPET set zt4.CARTOONPET.CARTOONID=zt4.CARTOONPET.CARTOONID+10000 where zt4.CARTOONPET.CARTOONID in (SELECT zt4.CARTOONPET.CARTOONID from zt.CARTOONPET)
3.SEPT表里SEPTID 处理重复,重复ID前加10000
update zt4.SEPT,zt.SEPT set zt4.SEPT.SEPTID= zt4.SEPT.SEPTID+10000 where zt4.SEPT.SEPTID in (select SEPTID from zt.SEPT)
4.UNIONMEMBER表里UNIONID处理重复前加10000
update zt4.UNIONMEMBER set zt4.UNIONMEMBER.UNIONID= zt4.UNIONMEMBER.UNIONID+10000 where zt4.UNIONMEMBER.UNIONID in (select UNIONID from zt.UNIONMEMBER)
5.UNIONMEMBER表里SEPTID 与SEPT表里的同步
update zt4.UNIONMEMBER,zt4.SEPT set zt4.UNIONMEMBER.SEPTID=zt4.SEPT.SEPTID WHERE zt4.UNIONMEMBER.NAME=zt4.SEPT.MASTER
6.UNION表里UNIONID 与UNIONMEMBER表里的同步
update zt4.UNION,zt4.UNIONMEMBER set zt4.UNION.UNIONID=zt4.UNIONMEMBER.UNIONID WHERE zt4.UNION.MASTER=zt4.UNIONMEMBER.NAME
7.SEPT表里UNIONID 与UNIONMEMBER表里的同步
update zt4.SEPT,zt4.UNIONMEMBER set zt4.SEPT.UNIONID=zt4.UNIONMEMBER.UNIONID WHERE zt4.SEPT.MASTER=zt4.UNIONMEMBER.NAME
8.CHARBASE表里SEPTID处理与SEPT表一致
update zt4.CHARBASE,zt4.SEPT set zt4.CHARBASE.SEPTID=zt4.SEPT.SEPTID WHERE zt4.CHARBASE.NAME=zt4.SEPT.NAME
9.CHARBASE表里UNIONID处理与UNIONMEMBER的UNIONID表一致
update zt4.CHARBASE,zt4.UNIONMEMBER set zt4.CHARBASE.UNIONID=zt4.UNIONMEMBER.UNIONID WHERE zt4.CHARBASE.NAME=zt4.UNIONMEMBER.NAME
10.SEPT表里CHARID与CHARBASE里的CHARID一致
update zt4.CHARBASE,zt4.SEPT set zt4.SEPT.CHARID=zt4.CHARBASE.CHARID WHERE zt4.CHARBASE.NAME=zt4.SEPT.MASTER
CARTOONPET表里MASTERID与CHARBASE里的CHARID一致
update zt4.CARTOONPET,zt4.CHARBASE set zt4.CARTOONPET.MASTERID=zt4.CHARBASE.CHARID where zt4.CHARBASE.NAME=zt4.CARTOONPET.MASTERNAME
12.UNIONMEMBER表里CHARID与CHARBASE里的CHARID一致
update zt4.CHARBASE,zt4.UNIONMEMBER set zt4.UNIONMEMBER.CHARID=zt4.CHARBASE.CHARID WHERE zt4.CHARBASE.NAME=zt4.UNIONMEMBER.NAME
13.SCHOOLMEMBER表里CHARID与CHARBASE里的CHARID一致
update zt4.CHARBASE,zt4.SCHOOLMEMBER set zt4.SCHOOLMEMBER.CHARID=zt4.CHARBASE.CHARID WHERE zt4.CHARBASE.NAME=zt4.SCHOOLMEMBER.NAME
14.CHARBASE表里NAME与主库CHARBASE名字重复的处理
update zt4.CHARBASE set name=CONCAT(rtrim(name),'oo') where name in (select name from zt.CHARBASE)
15.SEPT表里NAME与主库SEPT名字重复的处理
update zt4.SEPT set zt4.SEPT.NAME=CONCAT(rtrim(zt4.SEPT.NAME),'oo') where zt4.SEPT.NAME in (select NAME from zt.SEPT)
16.UNION表里NAME与主库UNION名字重复的处理
update zt4.UNION set zt4.UNION.NAME=CONCAT(rtrim(zt4.UNION.NAME),'oo') where zt4.UNION.NAME in (select NAME from zt.UNION)
17.SCHOOLMEMBER表里SERIALID与主库SCHOOLMEMBER名字重复的处理
update zt4.SCHOOLMEMBER set zt4.SCHOOLMEMBER.SERIALID=zt4.SCHOOLMEMBER.SERIALID+10000 where zt4.SCHOOLMEMBER.SERIALID in (select SERIALID from zt.SCHOOLMEMBER)
18.SEPT表里MASTER人物名与CHAREBASE里的人物名同步
update zt4.CHARBASE,zt4.SEPT set zt4.SEPT.MASTER=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.SEPT.CHARID
19.SCHOOLMEMBER表里NAME与CHARBASE人物名同步
update zt4.CHARBASE,zt4.SCHOOLMEMBER set zt4.SCHOOLMEMBER.NAME=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.SCHOOLMEMBER.CHARID
20.UNION表里MASTER人物名与CHAREBASE里的人物名同步
update zt4.CHARBASE,zt4.UNION set zt4.UNION.NAME=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.UNION.CHARID
22.CARTOONPET表里MASTERNAME与CHAREBASE里的人物名同步
update zt4.CHARBASE,zt4.CARTOONPET set zt4.CARTOONPET.MASTERNAME=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.CARTOONPET.MASTERID
21.合并CHARBASE数据库
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
22.合并SCHOOLMEMBER数据库
insert into zt.SCHOOLMEMBER SELECT * FROM zt4.SCHOOLMEMBER
23.合并SEPT数据库
insert into zt.SEPT SELECT * FROM zt4.SEPT
24.合并UNIONMEMBER数据库
insert into zt.UNIONMEMBER SELECT * FROM zt4.UNIONMEMBER
25.合并UNION
insert into zt.UNION SELECT * FROM zt4.UNION
26.合并CARTOONPET
insert into zt.CARTOONPET SELECT * FROM zt4.CARTOONPET
26.合并BALANCE
insert into zt.BALANCE SELECT * FROM zt4.BALANCE
cd /usr/local/mysql/bin/
mysqldump -u用户名 -p密码 –databases 库名 >/backdata/ddd07-11-15.sql
mysqldump –databases zt >/data/ok1.sql
cd /usr/local/mysql/bin/
mysql -uroot -pueoadir zt</backdata/kb.sql
mysqldump -uroot -pueoadir –databases zt >/backdata/back1210.sql
su - mysql -c “mysqld_safe –skip-name-resolve –open-files-limit=4096&”
cd /usr/local/mysql/bin/
mysql -uroot -pueoadir zt4</backdata/new.sql
mysql -uroot -pueoadir zt</data/ok.sql
UE处理下负区导入的表
mysql FLServer</data/FLServer.sql
mysql GMTool</data/GMTool.sql
mysql LoginServer</data/LoginServer.sql
mysql roleChangeServer</data/roleChangeServer.sql
mysql roleregServer</data/roleregServer.sql
mysql unify00</data/unify00.sql
mysql FLServer</data/FLServer.sql
mysql GMTool</data/GMTool.sql
mysql LoginServer</data/LoginServer.sql
mysql roleChangeServer</data/roleChangeServer.sql
mysql roleregServer</data/roleregServer.sql
mysql unify00</data/unify00.sql
mysql FLServer</data/FLServer.sql
mysql zt</data/zt501.sql
mysql -uroot -pueoadir zt</backdata/kb.sql
查询
select * from zt4.CHARBASE where name in (select name from zt.zHARBASE)
select * from CHARBASE limit 100
select UNIONID from CHARBASE limit 100
更新
update zt4.CHARBASE set name=CONCAT('一区',rtrim(name)) where name in (select name from zt.CHARBASE) ‘处理重名
update CHARBASE set name=CONCAT(rtrim(name),'1q')
update CHARBASE set CHARID=CHARID+10
插入
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
insert into game.user(name,pass) select name,pass from game2.user2
导入
mysql -uroot -pueoadir zt</backdata/zt2q.sql
mysql -uroot -pueoadir zt</backdata/1q.sql
删除
delete from CHARBASE WHERE ROUND=0 AND LEVEL < 80 and `LASTACTIVEDATE`< ‘2007-11-19 00:00:00′
delete from CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-19 00:00:00′
1.删除玩家离线时间超过五天且在线时间小于1小时的玩家!
delete from zt.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-12-10 00:00:00′
delete from zt.CHARBASE WHERE ROUND=0 AND LEVEL<80 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
2.去除GM CHARID编号重复
SELECT max(CHARID) FROM `CHARBASE`
update zt4.CHARBASE set CHARID=CHARID+10000 where CHARID < 100 LIMIT 50
update zt4.CHARBASE set CHARID=CHARID+20000 where CHARID in (select CHARID from zt.CHARBASE)
3.去除人物重名
update zt4.CHARBASE set name=CONCAT(rtrim(name),'o') where name in (select name from zt.CHARBASE)
4.插入表2数据到表1
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
________________________________________________
delete from zt4.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt4.CHARBASE WHERE ROUND=0 AND LEVEL<96 and `LASTACTIVEDATE`< ‘2007-12-10 00:00:00′
SELECT max(CHARID) FROM zt4.CHARBASE
select * from zt4.CHARBASE limit 100
update zt4.CHARBASE set CHARID=CHARID+10000 where CHARID in (select CHARID from zt.CHARBASE)
update zt4.CHARBASE set name=CONCAT(rtrim(name),'oo') where name in (select name from zt.CHARBASE)
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
___________________________________________________________________________________
1.删除玩家离线时间超过五天且在线时间小于1小时的玩家!
delete from zt.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt4.CHARBASE WHERE ROUND=0 AND ONLINETIME<4962 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt.CHARBASE WHERE ROUND=0 AND LEVEL<80 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
delete from zt4.CHARBASE WHERE ROUND=0 AND LEVEL<80 and `LASTACTIVEDATE`< ‘2007-11-22 00:00:00′
2.CHARBASE表里CHARID处理重复 重复ID 前加10000
update zt4.CHARBASE set zt4.CHARBASE.CHARID=zt4.CHARBASE.CHARID+10000 where zt4.CHARBASE.CHARID in (select CHARID from zt.CHARBASE)
CARTOONPET表里CARTOONID与主库CARTOONPET重复的处理
update zt4.CARTOONPET set zt4.CARTOONPET.CARTOONID=zt4.CARTOONPET.CARTOONID+10000 where zt4.CARTOONPET.CARTOONID in (SELECT zt4.CARTOONPET.CARTOONID from zt.CARTOONPET)
3.SEPT表里SEPTID 处理重复,重复ID前加10000
update zt4.SEPT,zt.SEPT set zt4.SEPT.SEPTID= zt4.SEPT.SEPTID+10000 where zt4.SEPT.SEPTID in (select SEPTID from zt.SEPT)
4.UNIONMEMBER表里UNIONID处理重复前加10000
update zt4.UNIONMEMBER set zt4.UNIONMEMBER.UNIONID= zt4.UNIONMEMBER.UNIONID+10000 where zt4.UNIONMEMBER.UNIONID in (select UNIONID from zt.UNIONMEMBER)
5.UNIONMEMBER表里SEPTID 与SEPT表里的同步
update zt4.UNIONMEMBER,zt4.SEPT set zt4.UNIONMEMBER.SEPTID=zt4.SEPT.SEPTID WHERE zt4.UNIONMEMBER.NAME=zt4.SEPT.MASTER
6.UNION表里UNIONID 与UNIONMEMBER表里的同步
update zt4.UNION,zt4.UNIONMEMBER set zt4.UNION.UNIONID=zt4.UNIONMEMBER.UNIONID WHERE zt4.UNION.MASTER=zt4.UNIONMEMBER.NAME
7.SEPT表里UNIONID 与UNIONMEMBER表里的同步
update zt4.SEPT,zt4.UNIONMEMBER set zt4.SEPT.UNIONID=zt4.UNIONMEMBER.UNIONID WHERE zt4.SEPT.MASTER=zt4.UNIONMEMBER.NAME
8.CHARBASE表里SEPTID处理与SEPT表一致
update zt4.CHARBASE,zt4.SEPT set zt4.CHARBASE.SEPTID=zt4.SEPT.SEPTID WHERE zt4.CHARBASE.NAME=zt4.SEPT.NAME
9.CHARBASE表里UNIONID处理与UNIONMEMBER的UNIONID表一致
update zt4.CHARBASE,zt4.UNIONMEMBER set zt4.CHARBASE.UNIONID=zt4.UNIONMEMBER.UNIONID WHERE zt4.CHARBASE.NAME=zt4.UNIONMEMBER.NAME
10.SEPT表里CHARID与CHARBASE里的CHARID一致
update zt4.CHARBASE,zt4.SEPT set zt4.SEPT.CHARID=zt4.CHARBASE.CHARID WHERE zt4.CHARBASE.NAME=zt4.SEPT.MASTER
CARTOONPET表里MASTERID与CHARBASE里的CHARID一致
update zt4.CARTOONPET,zt4.CHARBASE set zt4.CARTOONPET.MASTERID=zt4.CHARBASE.CHARID where zt4.CHARBASE.NAME=zt4.CARTOONPET.MASTERNAME
12.UNIONMEMBER表里CHARID与CHARBASE里的CHARID一致
update zt4.CHARBASE,zt4.UNIONMEMBER set zt4.UNIONMEMBER.CHARID=zt4.CHARBASE.CHARID WHERE zt4.CHARBASE.NAME=zt4.UNIONMEMBER.NAME
13.SCHOOLMEMBER表里CHARID与CHARBASE里的CHARID一致
update zt4.CHARBASE,zt4.SCHOOLMEMBER set zt4.SCHOOLMEMBER.CHARID=zt4.CHARBASE.CHARID WHERE zt4.CHARBASE.NAME=zt4.SCHOOLMEMBER.NAME
14.CHARBASE表里NAME与主库CHARBASE名字重复的处理
update zt4.CHARBASE set name=CONCAT(rtrim(name),'oo') where name in (select name from zt.CHARBASE)
15.SEPT表里NAME与主库SEPT名字重复的处理
update zt4.SEPT set zt4.SEPT.NAME=CONCAT(rtrim(zt4.SEPT.NAME),'oo') where zt4.SEPT.NAME in (select NAME from zt.SEPT)
16.UNION表里NAME与主库UNION名字重复的处理
update zt4.UNION set zt4.UNION.NAME=CONCAT(rtrim(zt4.UNION.NAME),'oo') where zt4.UNION.NAME in (select NAME from zt.UNION)
17.SCHOOLMEMBER表里SERIALID与主库SCHOOLMEMBER名字重复的处理
update zt4.SCHOOLMEMBER set zt4.SCHOOLMEMBER.SERIALID=zt4.SCHOOLMEMBER.SERIALID+10000 where zt4.SCHOOLMEMBER.SERIALID in (select SERIALID from zt.SCHOOLMEMBER)
18.SEPT表里MASTER人物名与CHAREBASE里的人物名同步
update zt4.CHARBASE,zt4.SEPT set zt4.SEPT.MASTER=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.SEPT.CHARID
19.SCHOOLMEMBER表里NAME与CHARBASE人物名同步
update zt4.CHARBASE,zt4.SCHOOLMEMBER set zt4.SCHOOLMEMBER.NAME=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.SCHOOLMEMBER.CHARID
20.UNION表里MASTER人物名与CHAREBASE里的人物名同步
update zt4.CHARBASE,zt4.UNION set zt4.UNION.NAME=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.UNION.CHARID
22.CARTOONPET表里MASTERNAME与CHAREBASE里的人物名同步
update zt4.CHARBASE,zt4.CARTOONPET set zt4.CARTOONPET.MASTERNAME=zt4.CHARBASE.NAME WHERE zt4.CHARBASE.CHARID=zt4.CARTOONPET.MASTERID
21.合并CHARBASE数据库
insert into zt.CHARBASE SELECT * FROM zt4.CHARBASE
22.合并SCHOOLMEMBER数据库
insert into zt.SCHOOLMEMBER SELECT * FROM zt4.SCHOOLMEMBER
23.合并SEPT数据库
insert into zt.SEPT SELECT * FROM zt4.SEPT
24.合并UNIONMEMBER数据库
insert into zt.UNIONMEMBER SELECT * FROM zt4.UNIONMEMBER
25.合并UNION
insert into zt.UNION SELECT * FROM zt4.UNION
26.合并CARTOONPET
insert into zt.CARTOONPET SELECT * FROM zt4.CARTOONPET
26.合并BALANCE
insert into zt.BALANCE SELECT * FROM zt4.BALANCE
清风细雨楼 Design By www.eepep.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
清风细雨楼 Design By www.eepep.com
暂无评论...
更新日志
2024年05月01日
2024年05月01日
- 齐秦《齐秦的世纪情歌之迷》24K GOLD [WAV+CUE][568M]
- 电子琴《汽车音响精品》5CD特效360度[WAV+CUE]
- 【古典音乐】卡拉扬《首次录音(4)》2006[FLAC+CUE整轨]
- 群星《巅峰煲碟皇·男人篇》[WAV+CUE]
- 2023年中国自研移动游戏全球流水TOP20:《原神》排名第三
- 《纸片马里奥RPG重置版》新预告 5月23日正式发售
- 蓄势待发了!开发商称对《寂静岭2RE》表现充满信心
- 梦剧院.1998-十年十美·十周年新曲+精丫乐意唱片】【WAV+CUE】
- 萧亚轩.2014-不解释亲吻【SONY】【WAV+CUE】
- 群星.2023-长风渡影视原声带【韶愔音乐】【FLAC分轨】
- 林慧萍1996-12-忘了我是女人[点将][WAV+CUE]
- 群星.2023-三体影视原声专辑【炎乐传媒】【FLAC分轨】
- 群星.2024-别对我动心影视原声带【千曜音乐】【FLAC分轨】
- 《明日方舟》联动中国电影资料馆 携手修复经典动画《铁扇公主》
- 《寂静岭2:重制版》开发商新作曝光:与T2合作开发的全新IP