mysql语句数据不换行

-- 查看当前数据库字符集
SHOW VARIABLES LIKE 'character_set_database';

-- 修改数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 修改表字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

$data = "第一行\n第二行";

SELECT CONCAT_WS('\n', field1, field2) AS formatted_data FROM your_table_name;

-- 创建表
CREATE TABLE articles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    content TEXT
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 插入数据
INSERT INTO articles (title, content) VALUES ('示例文章', '第一行\n第二行');

-- 查询数据并确保正确换行
SELECT CONCAT_WS('\n', title, content) AS formatted_article FROM articles;