[Tutor] Python + MySQL , my first simple program does not gives results

John Joseph jjk_saji at yahoo.com
Thu Jan 19 13:46:12 CET 2006

   I  tried out my first Pyhton program with MySQL 
             I was trying to get the  some result , eg
 describe table, select * from table
   but my program does not give the expected results ,
 nor it gives any error 
                 I am adding  my code in this mail 
                 Please guide me , why I am not
getting  any results displayed 
                                       Joseph John 

"""  For learning for
         To connect to a database "learnpython" , with
mysql user name "john" password "asdlkj"
         To describe a table "contact"
         To get result of  SQL statement


import MySQLdb
class learnpython_db:
        def __init__(self):
                db =
MySQLdb.connect(host="localhost",user =
"john",password = "asdlkj", db = learnpython)
                cursor = db.cursor()
                cursor.execute(" describe contact" )
                cursor.execute(" SELECT * from
contact" )

Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com

More information about the Tutor mailing list