第四篇：python操作数据库时的传参问题

def sql_func(time):<br>    time = "‘" + time + "‘"<br>    fail_sql=‘‘‘<br>    SELECT substr(s_start_time,1,10)  "日期",count(*)  "失败数量"<br>      FROM T_SG_WS_EXE_LOG L<br>     WHERE 1 = 1<br>       AND (S_WS_METHOD = ‘NotifyOrderStatus‘ OR (S_WS_METHOD = ‘placeOrder‘ AND S_IS_OK = ‘false‘))<br>    and s_request_str not like  ‘%"deployStatus":"2120"%‘ and s_request_str not like  ‘%"deployStatus":"0"%‘<br>    and  substr(s_start_time,1,10) = ‘‘‘<span style="color: #ff0000">+time +</span>‘‘‘group by substr(s_start_time,1,10) <br>    ‘‘‘<br>    # 使用cursor进行各种操作<br>    y=cr.execute(fail_sql)<br>    result = y.fetchall()<br>    return result<br><br>参考文档：https://www.cnblogs.com/goodhacker/p/3257882.html

第四篇：python操作数据库时的传参问题

标签：自己   失败   www.   hacker   als   group by   遇到   insert   log