mysql - 如何在MYSQL结果中插入换行符

Question

你如何做到这一点:

SELECT CONCAT(FIRST_NAME,' ' ,LAST_NAME, ADDRESS1, CITY,', ',STATE, ZIP) AS NAME

给出这样的结果:

Joe Donuts
123 Main St
New York, NY 11111

我尝试添加“\n”但无济于事。

Answer 1

尝试使用 CONCAT_WS 和 \n 作为换行符:

SELECT
    CONCAT_WS('\n', CONCAT(FIRST_NAME, ' ', LAST_NAME),
              ADDRESS1,
              CONCAT(CITY, ', ', STATE, ' ', ZIP)) AS NAME
FROM yourTable;

Demo