SQL 语句单引号的处理

 模糊查询带单引号

select fol.id,fol.product_name, fol.rel_phosee_layout
from fcwz_order fo,fcwz_order_line fol
where fol.mayi_order = fo.id
and fo.create_date > '2019-11-09 03:00:00'
and fol.product_name like '%台历%'
and fol.rel_phosee_layout like E'%\'sucai\'%';

或者再用一个单引号转义

sql = """
    select fol.id,fol.product_name, fol.rel_phosee_layout
    from fcwz_order fo,fcwz_order_line fol
    where fol.mayi_order = fo.id
    and fo.create_date > '2019-11-09 03:00:00'
    and fol.product_name like '%台历%'
    and fol.rel_phosee_layout like '%''sucai''%';
"""

插入或修改的数据有单引号

在python文件中

list = [{'width':110,'data':['123','456']},{'width':110,'data':['123','456']}]
str_list = str(list).replace("'", "\\'") 
# 先转义为
# str_list = [{\'width\': 110, \'data\': [\'123\', \'456\']}, {\'width\': 110, \'data\': [\'123\', \'456\']}]
# 再用E 
sql = """
    update fcwz_order_line set rel_phosee_layout = E'{}'
    where id = {}
""".format(str_list, 1222)