摘要:
UPDATE sale_origin_line set state='cancel' from sale_origin p,sale_origin_line q where p.id=q.order_id and p.company_id='3' and p.date<'2017-08-01'; 阅读全文
摘要:
sql1="select distinct SUBSTRING (name,3,8) from profin_application "cr.execute(sql1)dict1=cr.fetchall()i=0l=len(dict1)for i in range(l): print dict1[i 阅读全文