Example of Python Script to deal with MySQL

mysql.example.py

#!/usr/bin/python

import MySQLdb

conn = MySQLdb.connect (host = "host",
user = "us",
passwd = "pass",
db = "yourDB")
cursor = conn.cursor (MySQLdb.cursors.DictCursor )
cursor.execute ("SELECT * from yourTable")

rows = cursor.fetchall ()
for row in rows:
 print (row["name"], row["description"])
cursor.execute (' insert into anotherTable (id,name, description,price) values (6800, %s, %s, %s)', (row["name"], row["description"], 8.88))

print "number of all: %d" % cursor.rowcount

cursor.close ()
conn.commit()
conn.close ()