import MySQLdb as mdb
con = mdb.connect(host = 'localhost', user = 'root', passwd = 'ps', db = 'scrapy')
cur = con.cursor()
sql = """select * from table"""
cur.execute(sql)
rows = cur.fetchall()
import MySQLdb as mdb
con = mdb.connect(host = 'localhost', user = 'root', passwd = 'ps', db = 'scrapy')
cur = con.cursor()
sql = """select * from table"""
cur.execute(sql)
rows = cur.fetchall()