摘要:
CREATE VIEW user_algo_view ASselect `u`.`userId` AS `UserId`,`u`.`userCode` AS `UserCode`,group_concat(`al`.`id` separator ',') AS `AlgoIdList`,group_ 阅读全文
摘要:
ErrorMsg:The user specified as a definer ('root'@'%') does not exist解决方法:权限问题,授权 给 root 所有sql 权限 mysql> grant all privileges on *.* to root@"%" identi 阅读全文
摘要:
将 countertype 整数类型转成字符串类型 SELECT counterType, CASE counterType WHEN 1 THEN 'CTP'WHEN 2 THEN 'NULL'WHEN 3 THEN '飞鼠'WHEN 4 THEN '飞鼠 FIX'WHEN 5 THEN 'CTP 阅读全文