作业帮 > 综合 > 作业

select * from assets where assets.purchasedate between ${sta

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/04/29 16:52:53
select * from assets where assets.purchasedate between ${start} and ${end}
这么写mysql执行出错,该怎么写 其中start和end是从jsp页面传来的值
这样试试:
①去花括号
select * from assets where assets.purchasedate between $start and $end
②去花括号并且加引号
select * from assets where assets.purchasedate between '$start' and '$end'