Shulou(Shulou.com)06/01 Report--

Multiple fields are spliced into a single field for query

SELECT

CONCAT (area.name

House.block

'Dong'

House.unit

'unit'

House.room_number

'Room'

Room.apart_name) AS name

FROM

House_apart AS room

Query result

Name

Aaa', Room 1, Unit 1, Building 2, Shanghai

'Unit 1, Unit 1, Room A1, Building 2, Shanghai'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.