行侠仗义五千年 完整版手工端

tangwensen

链接失效了，可以补一个吗？感谢

鑫垚

kubbo

我补充一个视图可以用于后台充值不用不停的换表,然后在查询的时候吧表名换成视图名就可以了

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`