在执行sql="SELECT * FROM `civet_user`.t_uc_libra_loan_limit WHERE user_id='f2745de3-94ee-42ae-8728-e5b0073dd9cf'"
报错:
1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
找了很久才发现其实这是python中执行sql带有单双引号的转义问题.sql既有双引号又有单引号就会出现这样的问题
解决办法如下
def transferContent(self, content): if content is None: return None else: string = "" for c in content: if c == '"': string += '' elif c == "'": string += "\'" elif c == "\\": string += "\\\\" else: string += c return string