Python: MySQL-Python library #python #sql

Snipplr-29633.py

import MySQLdb

conn = MySQLdb.connect(host=\"localhost\", user=\"root\", passwd=\"nobodyknow\", db=\"amit\")
cursor = conn.cursor()

stmt = \"SELECT * FROM overflows\"
cursor.execute(stmt)

# Fetch and output
result = cursor.fetchall()
print result

# get the number of rows
numrows = int(cursor.rowcount)

# Close connection
conn.close()

is it workingg?