不可轻言放弃,否则对不起自己!
sqlite python执行delete报错
上一篇 /
下一篇 2013-12-06 15:54:49
/ 个人分类:测试知识
#coding=gbk
from sqlite3 import dbapi2
# 打开
数据库 c:\mytest.db
conn=dbapi2.connect("c:\\mytest.db")
# 创建数据表 mytb
sql1 = "CREATE TABLE IF NOT EXISTS mytb1 ( a char , b int , c real )"
sql2 = "CREATE TABLE IF NOT EXISTS mytb2 ( a char , b int , c real )"
sql3 = "CREATE TABLE IF NOT EXISTS mytb3 ( a char , b int , c real )"
conn.execute( sql1 )
conn.execute( sql2 )
conn.execute( sql3 )
cs = conn.cursor( )
cs.execute("SELECT name FROM sqlite_master WHERE type='table'")
records = cs.fetchall()
for i in range(len(records)):
print 'i:',i
print 'records:',records[i][0]
#cs.execute("DELETE FROM %s " % records[i][0])
cs.execute('delete from ?' ,records[i][0])
conn.commit()
cs.close()
conn.close()
===============================
sqlite3.OperationalError: near "?": syntax error
收藏
举报
TAG: