python3 sql语句executemany问题
PHPz
PHPz 2017-04-17 17:16:23
0
1
426

python3 sql语句不能用%s吗,只能用问号吗?
另外,在执行sql语句的时候一直报错是怎么回事

yield_sql = "SELECT  A.SecuCode, A.SecuAbbr, ChangePCT FROM SecuMain A
WHERE A.SecuCode =%s AND A.TradingDay=%s"

values的值如下:
[('430003', '2010-08-27'),
('002051', '2009-07-24'),
('002051', '2012-03-17'),
('002052', '2009-02-14'),
('002055', '2010-05-15'),
('002055', '2014-07-28'),
('600048', '2009-02-18')]
像这样一次查询多个的可以用cur.executemany()吗,有什么便捷的方法,求指教!

PHPz
PHPz

学习是最好的投资!

reply all(1)
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!