stefanmonkey/get_data.py

## get_data.py
#!/usr/bin/python
# -*- coding: utf-8 -*-

import MySQLdb as mdb

con = mdb.connect('localhost', 'testuser', '123456', 'testdb');

with con:

    cur = con.cursor()
    cur.execute("SELECT * FROM Writers")

    rows = cur.fetchall()

    for row in rows:
        print row
	#!/usr/bin/python
	# -- coding: utf-8 --

	import MySQLdb as mdb

	con = mdb.connect('localhost', 'testuser', '123456', 'testdb');

	with con:

	cur = con.cursor()
	cur.execute("SELECT * FROM Writers")

	rows = cur.fetchall()

	for row in rows:
	print row