不可轻言放弃,否则对不起自己!

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:

 

评分:0

我来说两句

Open Toolbar