同一个字符串同样的规则替换为不同的数据python

[My梦]

str=“select id，age，name from dbname where age=｛age｝and name=｛name｝” agelist=[12,13,14] namelist=["xiaoming","xiaohong"] 最终需要的结果 "select id，age，name from dbname where age=12 and name=xiaoming" "select id，age，name from dbname where age=12 and name=xiaohong" "select id，age，name from dbname where age=13 and name=xiaoming" "select id，age，name from dbname where age=13 and name=xiaohong" "select id，age，name from dbname where age=14 and name=xiaoming" "select id，age，name from dbname where age=14 and name=xiaohoong"

[shoppo0505]

用for循环阿，有什么问题吗？

[My梦]

解决办法见下面文章： https://blog.csdn.net/weixin_43614573/article/details/111173529