Reading from a Database : MySQL « Database « Python

Python

1.	2D
2.	Application
3.	Buildin Function
4.	Class
5.	Data Structure
6.	Data Type
7.	Database
8.	Development
9.	Dictionary
10.	Event
11.	Exception
12.	File
13.	Function
14.	GUI Pmw
15.	GUI Tk
16.	Language Basics
17.	List
18.	Math
19.	Network
20.	String
21.	System
22.	Thread
23.	Tuple
24.	Utility
25.	XML

Java

Java Tutorial

Java Source Code / Java Documentation

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Python » Database » MySQL

Screenshots

Reading from a Database








import MySQLdb



db= MySQLdb.connect(host="localhost", user="python-test", passwd="python",

db="python-test")



cursor = db.cursor()

stmt = "SELECT * from books"

cursor.execute(stmt)



rows = cursor.fetchall ()

for row in rows:

    print "Row: "

    for col in row :

        print "Column: %s" % (col)

    print "End of Row"

print "Number of rows returned: %d" % cursor.rowcount



cursor.close()



db.close()

Related examples in the same category

1.	Updating a Database
2.	Writing to a Database

w__ww___.ja___v_a_2___s___.___com__ | Contact Us

All other trademarks are property of their respective owners.