mysql导出问号

-- 检查包含问号的记录
SELECT * FROM your_table WHERE your_column LIKE '%?%';

-- 清理问号
UPDATE your_table SET your_column = REPLACE(your_column, '?', '') WHERE your_column LIKE '%?%';

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database'
}

cnx = mysql.connector.connect(**config)
cursor = cnx.cursor()

query = "SELECT * FROM your_table WHERE some_condition = %s"
params = ('some_value',)

cursor.execute(query, params)

for row in cursor:
    print(row)

cursor.close()
cnx.close()

mysqldump -u your_user -p your_database > backup.sql