A Short Python Example
Listing E.1 runs you through the basics of connecting, running queries, and processing results.Listing E.1: example.py
#!/usr/bin/env python
import MySQLdb
dbh = None
try:
dbh = MySQLdb.connect(user='guru2b', passwd='g00r002b',–
host='test.host.co.za', db='firstdb')
except:
print "Could not connect to MySQL server."
exit(0)
try:
cursor = dbh.cursor()
cursor.execute("UPDATE customer SET surname='Arendse' WHERE–
surname='Burger'")
print "Rows updated: ", cursor.rowcount
cursor.close()
except:
print "Could not update the table."
try:
cursor = dbh.cursor()
cursor.execute("SELECT first_name,surname FROM customer")
for row in cursor.fetchall():
print "Name: ", row[0], row[1]
dbh.close()
except:
print "Failed to perform query"
dbh.close()
لطفا منتظر باشید ...
