python3 ,input的量怎么在sql语法里面使用
老壶 2019-11-09 07:36:40 python3 input变量能不能在sql语法里面调用
begin=input('请输入开始日期')
end=input('请输入开始日期')
result = cursor.execute(
'select pro_class,pro_id,pro_name,pro_spec,pro_unit,pro_city, \
pro_normal_price ,pro_last_in_price ,pro_special_code , \
sum(psl_qty),sum(psl_qty*psl_unit_cost),sum(psl_amt) \
from pos.product,pos.p_sale \
where psl_date>= begin \
and psl_date<= end \
and psl_pro_id = pro_id\
group by pro_class,pro_id,pro_name,pro_spec,pro_unit,\
pro_city,pro_normal_price,pro_last_in_price,pro_special_code '