SELECT concat(host,uri),ua FROM httpdataco WHERE uri LIKE '%BaiduApp_signed%';
要点是concat这个函数实现拼接
实现特殊字符串进行连接用concat_ws:
select CONCAT_WS("我是分隔符",username,passwd) as result FROM userdata ;
SELECT concat(host,uri),ua FROM httpdataco WHERE uri LIKE '%BaiduApp_signed%';
要点是concat这个函数实现拼接
实现特殊字符串进行连接用concat_ws:
select CONCAT_WS("我是分隔符",username,passwd) as result FROM userdata ;