DELETE 操作-python实现

sunlichao

下面的 Python 代码显示了如何使用 DELETE 语句删除任何记录，然后从 COMPANY 表中获取并显示剩余的记录：

1. #!/usr/bin/python
   
2. 
   
3. import sqlite3
   
4. 
   
5. conn = sqlite3.connect('test.db')
   
6. print "Opened database successfully";
   
7. 
   
8. conn.execute("DELETE from COMPANY where ID=2;")
   
9. conn.commit()
   
10. print "Total number of rows deleted :", conn.total_changes
    
11. 
    
12. cursor = conn.execute("SELECT id, name, address, salary  from COMPANY")
    
13. for row in cursor:
    
14.    print "ID = ", row[0]
    
15.    print "NAME = ", row[1]
    
16.    print "ADDRESS = ", row[2]
    
17.    print "SALARY = ", row[3], "\n"
    
18. 
    
19. print "Operation done successfully";
    
20. conn.close()

复制代码

上述程序执行时，它会产生以下结果：

1. Opened database successfully
   
2. Total number of rows deleted : 1
   
3. ID =  1
   
4. NAME =  Paul
   
5. ADDRESS =  California
   
6. SALARY =  20000.0
   
7. 
   
8. ID =  3
   
9. NAME =  Teddy
   
10. ADDRESS =  Norway
    
11. SALARY =  20000.0
    
12. 
    
13. ID =  4
    
14. NAME =  Mark
    
15. ADDRESS =  Rich-Mond
    
16. SALARY =  65000.0
    
17. 
    
18. Operation done successfully

复制代码