python mysql 插入特殊符号出错
sql2 = “insert into posts(key_int,title_desc,videos,ok) values (%s,%s,%s,%s)” try: cursor.execute(sql2, (kid,tdjson,ytbjson,1)) conn.commit() sql1 = “update mainkeys set ok=1 where id = ‘%s'” % (kid) cursor.execute(sql2) conn.commit() except: conn.rollback()