使用sql语句查询日期在一周内的数据
select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0 //查询当天日期在一周年的数据
select * from ShopOrder where datediff(day,ordTime,getdate()-1...
# 取单价为最近时间的单价sql="select price_unit from sale_price_list where partner_id=%d and product_id=%d order by write_date desc limit 1"%(partner_id,product_id)cr.execute(sql)delete from stock_p...
UPDATE v9_k12_homework_tea
SET `yufa_type` = CASE `yufa_type`
WHEN 0 THEN '0'
WHEN 1 THEN '31'
WHEN 2 THEN '43'
WHEN 3 THEN '48'
WHEN 4 THEN '60'
WHEN 5 THEN '61'
WHEN 11 THEN '181'
WHEN 13 THEN '20...
mysql【创建账号】：create user 'finance'@'%' IDENTIFIED BY ‘xxx’;【给数据库权限】：grant all on database.* to 'finance'@'%';all可以换成 select,update,….【撤销权限】：revoke all on *.* from 'finance...
