mysql_example.py

import MySQLdb

connector = MySQLdb.connect(host="localhost", db="dbname", user="user", passwd="paswd", charset="utf8")
cursor = connector.cursor()
cursor.execute("select * from table limit 100")
result = cursor.fetchall()

if len(result) == 0:
    print("no arecords. exit.")
    cursor.close()
    connector.close()
    exit(0)
    
items = [item[0] for item in result]

for item in items:

    print item


cursor.execute("INSERT INTO table (col1, col2, col3, created) VALUES (%s, %s, %s, NOW())",(val1, "val2", 0))

connector.commit()
cursor.close()
connector.close()