PostgreSQL连接Python(1)(3)
DELETE 操作
Python代码显示了如何我们可以使用DELETE语句删除记录,然后获取并显示COMPANY 表剩余的记录:
- #!/usr/bin/python
- import psycopg2
- conn = psycopg2.connect(database="testdb", user="postgres", password="pass123", host="127.0.0.1", port="5432")
- print "Opened database successfully"
- cur = conn.cursor()
- cur.execute("DELETE from COMPANY where ID=2;")
- conn.commit
- print "Total number of rows deleted :", cur.rowcount
- cur.execute("SELECT id, name, address, salary from COMPANY")
- rows = cur.fetchall()
- for row in rows:
- print "ID = ", row[0]
- print "NAME = ", row[1]
- print "ADDRESS = ", row[2]
- print "SALARY = ", row[3], "\n"
- print "Operation done successfully";
- conn.close()
当上述程序执行时,它会产生以下结果:
- Opened database successfully
- Total number of rows deleted : 1
- ID = 1
- NAME = Paul
- ADDRESS = California
- SALARY = 20000.0
- ID = 3
- NAME = Teddy
- ADDRESS = Norway
- SALARY = 20000.0
- ID = 4
- NAME = Mark
- ADDRESS = Rich-Mond
- SALARY = 65000.0
- Operation done successfully
评论关闭