mysql 查询不换行

-- 检查数据库字符集
SHOW CREATE DATABASE your_database_name;

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

-- 检查表字符集
SHOW CREATE TABLE your_table_name;

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

INSERT INTO your_table_name (text_column) VALUES (REPLACE('your\ntext', '\n', '<br>'));

SELECT REPLACE(text_column, '\n', '<br>') AS formatted_text 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 ('Sample Article', 'This is the first line.\nThis is the second line.');

-- 查询数据并处理换行符
SELECT title, REPLACE(content, '\n', '<br>') AS formatted_content FROM articles;