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)

Comments

C programing : File

/* Program to take lines 1,4,7,10.... from a text file and to write into a new file. It is written in c with platform devcpp*/ /* eg:- input file -> ab.txt contain 1 lady gaga sdrgrg ergerg 2 oraph winfrey dfgdr dfgdf . output file neww.txt 1 lady gaga 2 oraph winfrey . . */ #include #include #include using namespace std; main() { char c; FILE *fp1,*fp2; if(fp1=fopen("e:\\ab.txt","r")) { cout<<"\n opened fp1"; } else { cout<<"\n failed fp1"; } if( fp2=fopen("e:\\neww.txt","w") ) { cout<<"\n opened fp2"; } else { cout<<"\n failed fp2"; } while(!feof(fp1)) { c=getc(fp1); while(c!='\n') { putc(c,fp2); c=getc(fp1); } putc('\n',fp2); c=getc(fp1); while(c!='\n') { c=getc(fp1); } c=getc(fp1); while(c!='\n') { c=getc(fp1); } } cout<<"\n End"; getch(); return 0; }

OpenCV installation with Visual Studio 2010

Hi all.I will show you how to install OpenCV library in windows with Visual Studio 2010 to use with Visual C++ Here I am show to install OpenCV Ver 2.2. 1. Download the OpenCV from source forge The link is : http://sourceforge.net/projects/opencvlibrary/files/opencv-win/ 2. Install the OpenCV to any drive.I have installed as C:\OpenCV2.2 3. Next open Visual Studio 2010.Select New>Project 4. Select Win32 Console Application from Visual C++ popup. 5. Give the project a name and press OK . I gave as 'helloworld' 6. Click Finish to continue.You can see a new file has opened where you can type your code. 7. Next select Project> <your project name> Properties . 8. Go to VC++ Directories and select Include Directories.There add the two links to that a) C:\OpenCV2.2\include b) C:\OpenCV2.2\include\opencv 9. Next Go to Library Directories and add the following link a) C:\OpenCV2.2\lib 10. Now Go to Linker option from the left

Install sublime editor

Hi. Sublime editor is a light weight editor and very helpful for developers to write code.It will highlight the code in colors for easy readability. Sublime editor 3 is the latest one available as of now . The below link shows how to install sublime editor in CentOS . http://software-engineer.gatsbylee.com/how-to-install-sublime-3-on-centos-7-rhel-7/ To know about you system OS is 32 bit or 64 bit , use the below command. >uname -a

Tech Info Talks

Search This Blog