tangwensen
发表于 2025-3-20 10:40:44
链接失效了,可以补一个吗?感谢
鑫垚
发表于 2025-4-17 21:39:29
::
kubbo
发表于 2025-5-24 22:22:00
我补充一个视图可以用于后台充值不用不停的换表,然后在查询的时候吧表名换成视图名就可以了
select `dbroledata_0`.`Name` AS `Name`,cast(`dbroledata_0`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_0`.`Uin` AS `Uin` from `dbroledata_0` union all select `dbroledata_1`.`Name` AS `Name`,cast(`dbroledata_1`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_1`.`Uin` AS `Uin` from `dbroledata_1` union all select `dbroledata_2`.`Name` AS `Name`,cast(`dbroledata_2`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_2`.`Uin` AS `Uin` from `dbroledata_2` union all select `dbroledata_3`.`Name` AS `Name`,cast(`dbroledata_3`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_3`.`Uin` AS `Uin` from `dbroledata_3` union all select `dbroledata_4`.`Name` AS `Name`,cast(`dbroledata_4`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_4`.`Uin` AS `Uin` from `dbroledata_4` union all select `dbroledata_5`.`Name` AS `Name`,cast(`dbroledata_5`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_5`.`Uin` AS `Uin` from `dbroledata_5` union all select `dbroledata_6`.`Name` AS `Name`,cast(`dbroledata_6`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_6`.`Uin` AS `Uin` from `dbroledata_6` union all select `dbroledata_7`.`Name` AS `Name`,cast(`dbroledata_7`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_7`.`Uin` AS `Uin` from `dbroledata_7` union all select `dbroledata_8`.`Name` AS `Name`,cast(`dbroledata_8`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_8`.`Uin` AS `Uin` from `dbroledata_8` union all select `dbroledata_9`.`Name` AS `Name`,cast(`dbroledata_9`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_9`.`Uin` AS `Uin` from `dbroledata_9` union all select `dbroledata_10`.`Name` AS `Name`,cast(`dbroledata_10`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_10`.`Uin` AS `Uin` from `dbroledata_10` union all select `dbroledata_11`.`Name` AS `Name`,cast(`dbroledata_11`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_11`.`Uin` AS `Uin` from `dbroledata_11` union all select `dbroledata_12`.`Name` AS `Name`,cast(`dbroledata_12`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_12`.`Uin` AS `Uin` from `dbroledata_12` union all select `dbroledata_13`.`Name` AS `Name`,cast(`dbroledata_13`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_13`.`Uin` AS `Uin` from `dbroledata_13` union all select `dbroledata_14`.`Name` AS `Name`,cast(`dbroledata_14`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_14`.`Uin` AS `Uin` from `dbroledata_14` union all select `dbroledata_15`.`Name` AS `Name`,cast(`dbroledata_15`.`RoleID` as char(20) charset utf8mb4) AS `RoleID`,`dbroledata_15`.`Uin` AS `Uin` from `dbroledata_15`
Snail丿
发表于 2025-7-23 12:08:57
大佬,服务端的bin文件怎么解密啊