First of all you have to install python-MySQLdb which interacts between the My-SQL database and the Python.So to install it in the Raspberry-Pi terminal type..
sudo apt-get install python-mysqldb
I have already installed so my screenshot is looking like this..after installing this nothing else is required..
Move to the desktop and open the Python IDLE.Remember don’t open the IDLE 3 as it doesn’t supports the MySQLdb.
Now in the prompt type
if it shows some error then the MySQLdb is not installed.If it is installed then it will show nothing.In the IDLE click on File and New Window this will open a new editor to write the python codes.
Now lets you have a database dbase and user is root and PWD is pwd and has a table tab and some stored data.Here is my database snap…
Now in the editor write the following code and save it by pressing ctrl+s and execute it by pressing F5.It will show you the results in the IDLE shell.
#tab is a table in the database
curs.execute("SELECT * FROM tab")
for reading in curs.fetchall():
print str(reading )
Latest posts by Bikash Panda (see all)
- OSMC on Raspberry PI with Setup and Control using Android App - July 7, 2017
- DHT12 Interfacing with Raspberry Pi using Pi4J - June 19, 2017
- Send data using MQTT from Raspberry Pi with JAVA - June 12, 2017