Mastering Python Scripting for System Administrators

Retrieving the data

To retrieve the data from the table, we use the select statement. Now, we are going to retrieve the data from our books table. For that, create a retrieve_data.py script and write the following content in it:

import MySQLdb as mdbcon_obj = mdb.connect('localhost', 'test_user', 'test123', 'test')with con_obj:            cur_obj = con_obj.cursor()            cur_obj.execute("SELECT * FROM books")            records = cur_obj.fetchall()            for r in records:                        print(r)

Run the script and you will get the output as follows:

student@ubuntu:~/work/mysql_testing$ python3 retrieve_data.pyOutput:(1, 'Harry Potter')(2, 'Lord of the rings')(3, 'Murder on the Orient Express')(4, 'The adventures of Sherlock Holmes')(5, 'Death on the Nile')

In the preceding example, we retrieved ...