Using mysql db with Python-MySQLConnection

There are many examples of using datasets in python but very less references of accessing database such as MySQL into python code, so I need help in order to access MySQL database from python code, where i can select records from the database table and also update the values back to the database.