mysql清除数据库的换行

UPDATE table_name SET column_name = REPLACE(column_name, '\n', ' ');

import mysql.connector

db = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

cursor = db.cursor()
cursor.execute("SELECT column_name FROM table_name")
rows = cursor.fetchall()

for row in rows:
  replaced_text = row[0].replace('\n', ' ')
  # 更新数据库中的值
  update_query = "UPDATE table_name SET column_name = %s WHERE column_name = %s"
  cursor.execute(update_query, (replaced_text, row[0]))

db.commit()