“||”：字符拼接

select 'a' || 'b' //结果是ab

查询字段，实例：

SELECT (`parent_path`||`server_filename`)'path','12312344' as 'uk' FROM "cache_file" limit 0, 100