青山止酒停云老的博客mysql 版本5.7kingBase 版本V8R3一、data_format不支持mysql查询:SELECTDATE_FORMAT(rra.create_time, '%Y-%m') AS MONTH,SUM( CASE WHEN rrm.resource_type = 'table' THEN 1 ELSE 0 END ) AS tableTotal,SUM(CASE...
我只会发热的博客9、关联表字段存在类型不一致的情况,需要用 :: varchar 做类型转换(例:SELECT * FROM ghalarm_history h LEFT JOIN ghgis_config c on c.device_id=d.id or c.device_id :: varchar = CONCAT(‘cam_’,d.id));...