MySQL in Python

Using _mysql from deb package python-mysqldb

Documentation: mysql-python.sourceforge.net

apt-get install python-mysqldb

#!/usr/bin/python

import _mysql

db = _mysql.connect(host="testing-db.dev", db="mydb", user="myuser", passwd="mypass")
db.query("SELECT * FROM testing_table LIMIT 1")
res = db.store_result()
row = res.fetch_row()
# row contains the simple list
print row

Using MySQLdb

#!/usr/bin/python

import MySQLdb

db = MySQLdb.connect(host="testing-db.dev", db="mydb", user="myuser", passwd="mypass")
c = db.cursor() # optional parameter for changing the cursor type (= the result as list or dict)
c.execute("SELECT * FROM testing_table LIMIT 1")
row = c.fetchone()
#rows = c.fetchall()
print row