cur.executescript不能正常运行
下面的程序运行正常。import sqlite3
con=sqlite3.connect(":memory:")
cur=con.cursor()
sql1="attach database 'g:\\workspace\\data\\Cinfo.sqlite' as Cinfo;"
sql2="select * from Cinfo.ipo;"
cur.execute(sql1)
cur.execute(sql2)
con.commit()
x=cur.fetchall()
print(x)
如果替换成,将出现问题，得不到任何结果。
import sqlite3
con=sqlite3.connect(":memory:")
cur=con.cursor()
sql_script="""
attach database 'g:\\workspace\\data\\Cinfo.sqlite' as Cinfo;
select * from Cinfo.ipo;"""
cur.executescript(sql_script)
con.commit()
x=cur.fetchall()
print(x)
请您将附件下载后，解压，存放至 g:\\workspace\\data\\Cinfo.sqlite，测试一下。
http://osdir.com/ml/python.db.pysqlite.user/2006-06/msg00004.html
executescrit 中不能用select
页:
[1]