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



















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




























UNIX : unpack and pack using tar 




























 Tarball or tar is a utility in linux to unpack or pack the files.   Lets say we have a file name hello.tar.gz which is packed and compressed.   To unpack the file use the below command    > tar xvzf hello.tar.gz     This is unpack the compressed tarball file to the directory hello in current location.   To pack a list of files to a compressed tarball file , we can follow the below steps.   Let say we have the following list of files in Hello directory.   > cd Hello   > ls  helloworld.py  README.txt   Move back to parent directory and give the below command.   > cd ..    > tar zcvf hello.tar.gz Hello    This will create the compressed tar file in the current location   




















Post a Comment









Read more