今天在写python脚本时遇到如标题的问题,发现自己所写脚本里存在问题。
错误的代码示例:
cursor.execute("SELECT xoi.order_id
,xoi.order_sn
,xu.email
,xoi.order_status
,xoi.shipping_status
,xoi.pay_status
FROM
yamibuy_master.xysc_order_info AS xoi
INNER JOIN yamibuy_master.xysc_users AS xu ON xoi.user_id =
xu.user_id
WHERE
xu.email IN ( 'qa_a.xa@yamibuy.com', 'qa_b.xa@yamibuy.com',)
AND xoi.order_status NOT IN ( 4, 5, 2 )
AND xoi.shipping_status NOT IN ( 8, 1, 0 )
AND xoi.pay_status NOT IN ( 0, 2, 3, 4 );" </