mysql地段内容换行

CREATE TABLE articles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    content TEXT
);

import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 插入数据
content = "This is the first line.\nThis is the second line."
cursor.execute("INSERT INTO articles (title, content) VALUES (%s, %s)", ("Sample Article", content))

db.commit()
cursor.close()
db.close()

import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 检索数据
cursor.execute("SELECT content FROM articles WHERE id = %s", (1,))
result = cursor.fetchone()

if result:
    content = result[0]
    # 处理换行符
    formatted_content = content.replace('\n', '<br>')
    print(formatted_content)

cursor.close()
db.close()