mysql老是换行

import re

def clean_newlines(data):
    return re.sub(r'\n|\r\n', '', data)

cleaned_data = clean_newlines(original_data)
# 然后将cleaned_data插入到MySQL中

CREATE TABLE example (
    id INT PRIMARY KEY,
    content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);

SELECT REPLACE(REPLACE(content, '\n', ''), '\r\n', '') AS cleaned_content FROM example;

import mysql.connector
import re

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

# 创建表
cursor.execute("""
CREATE TABLE IF NOT EXISTS example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
)
""")

# 插入数据前预处理换行符
def clean_newlines(data):
    return re.sub(r'\n|\r\n', '', data)

original_data = "This is a test.\nWith some new lines."
cleaned_data = clean_newlines(original_data)

# 插入数据
cursor.execute("INSERT INTO example (content) VALUES (%s)", (cleaned_data,))
db.commit()

# 查询数据并处理换行符
cursor.execute("SELECT REPLACE(REPLACE(content, '\\n', ''), '\\r\\n', '') AS cleaned_content FROM example")
results = cursor.fetchall()

for result in results:
    print(result[0])

# 关闭连接
cursor.close()
db.close()