12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-12-25 09:56:35
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
多个字段拼接成一个字段进行查询
SELECTCONCAT(area.name,house.block,'栋',house.unit,'单元',house.room_number,'室',room.apart_name) AS name,FROMhouse_apart AS room
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
多个字段拼接成一个字段进行查询
SELECT
CONCAT(area.name,
house.block,
'栋',
house.unit,
'单元',
house.room_number,
'室',
room.apart_name) AS name,
FROM
house_apart AS room;
查询结果
name
'上海2栋1单元1室Aaa'
'上海2栋1单元1室A1'
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19