Skip to main content

Python : Reading records from mysql table with python


To read records from a mysql table in python we can use the below code. Please refer to my previous post for the table structure and records inserted into the table in sql-inserting-records-into-mysql-table post. To connect to mysql database from python MySQLdb library is used. You can refer the post on how to install MySQLdb here.

#!/usr/bin/python

import MySQLdb

dbconnection = MySQLdb.connect(host = "localhost",
          user = "username",
          passwd = "password",
          db = "pydatabase")

cursor = dbconnection.cursor()

sql = "select * from pytable"

cursor.execute(sql)

for record in cursor.fetchall():
 print record










on running the program it fetches all the records from the table pytable and loads into a cursor. With a for loop the records are printed. The output of the above program is displayed here.






(1L, 'Snikers', 'CH', datetime.date(2016, 8, 5), 100.0)
(2L, 'Galaxy', 'CO', datetime.date(2015, 1, 1), 200.0)
(3L, 'Butterfinger', 'CN', datetime.date(2016, 8, 5), 150.0)















Labels:






























Comments











Post a Comment






























Popular posts from this blog





















Pokemon Go download link




























      Pokemon go has become the buzz word in tech industry now. Nintendo, the Japanese video game company are the creates of this game. Its first of it kind to integrate a game with augmented reality , so people has to go out to real world with there android or iPhone to catch em all . You can download  Pokemon go  from this link.    




















2 comments









Read more





























UNIX : How to ignore lines with certain names 




























  Sometimes we need to ignore multiple lines with certain words and get the list out of the file. usually it will be a log file to read . The below grep command can be used to ignore multiple words present in a text file.   Lets say the file contain   $ cat list.txt  apple  orange  apple  banana  papaya   Now we need to ignore line with orange , banana and papaya . So we can use the below grep command.   $ cat list.txt | grep -Ev "orange|banana|papaya"  apple  apple   It will ignore lines with the words in -v part of grep.  




















Post a Comment









Read more