ThinkChat🤖让你学习和工作更高效,注册即送10W Token,即刻开启你的AI之旅 广告
## concat_ws,concat ### 说明 | 函数 | 说明 | | --- | --- | | concat_ws(sep,s1,s2...,sn) | 将s1,s2...,sn连接成字符串,并用sep字符间隔 | | concat(s1,s2...,sn) | 连接成字符串s1,s2...,sn | ### 例子:查询宝宝月龄 ```sql SELECT id, longitude, latitude, concat_ws(',', longitude, latitude) AS location, concat('经纬度:',longitude,',',latitude) as location1 FROM user_address_10000 LIMIT 10; ```