01 2021 档案
摘要：import smtplib import pymysql import pymysql import pandas as pd from email.mime.text import MIMEText from email.utils import formataddr def data_out_
阅读全文
摘要：SELECT DISTINCT pp.物料编码, pp.物料名称, IFNULL(pp.规格型号, '') AS 规格型号 , pp.物料类型, pp.单位, max1.日期 AS 最新日期, max1.单价 AS 最新价, max2.日期 AS 上一次日期 , max2.单价 AS 上一次价 ,
阅读全文
摘要：t_punch_cade select a.*,(@i := @i + 1) as ord_num from t_punch_cade a,(select @i := 1) d order by user_id,punch_time select a.*,(@j := @j + 1) as ord_
阅读全文
摘要：import pymysql import pandas as pd DB = {'host': '****', 'port': ####, 'user': 'root', 'password': '#####', 'dbname': '%%%%'} def data_out_msql(DB, ms
阅读全文
