""" import """
import MySQLdb


""" connecting """
db = MySQLdb.connect(user="se4_2006", passwd="return", db="se4_2006")


""" create a cursor """
cursor = db.cursor()


""" query """
cursor.execute("SELECT * FROM python_test")


""" fetch results """
result = cursor.fetchall()


""" extract results """
for record in result:
    print record

""" insert """
#cursor.execute("""INSERT INTO python_test (firstname, lastname, email, phone) VALUES ("John", "Doe", "jd@mail.com", "1234567")""")

""" delete """
#cursor.execute("DELETE FROM python_test WHERE firstname = 'John'")