如果构建的sql中包含百分号,如:
INSERT INTO child (pk, data_id, material_type) VALUES ('5e995e464bec3a00067402f4_0', '5e995e464bec3a00067402f4', '28%');
则会报错:
ValueError: unsupported format character '?'
搜索后需要将’%‘替换为’%%’
sql = "INSERT INTO child (pk, data_id, material_type) VALUES ('5e995e464bec3a00067402f4_0', '5e995e464bec3a00067402f4', '28%%');"
sql = sql.replace('%', '%%')