python-mysqlHow can I retrieve unread results from a MySQL database using Python?

The following code snippet shows an example of how to retrieve unread results from a MySQL database using Python. The code uses the SELECT statement to query the database, the WHERE clause to specify the condition for retrieving unread results, and the fetchall() method to return the results:

import mysql.connector

# Connect to the MySQL database
conn = mysql.connector.connect(user='user', password='password',
                              host='host',
                              database='dbname')

# Create a cursor
cursor = conn.cursor()

# Execute the query
query = "SELECT * FROM table WHERE status='unread'"
cursor.execute(query)

# Fetch the results
results = cursor.fetchall()

# Print the results
print(results)

Output example

[('data1', 'unread'), ('data2', 'unread'), ('data3', 'unread')]

The code consists of the following parts:

1. Importing the mysql.connector module, which provides a Python interface for connecting to a MySQL database.
2. Establishing a connection to the database using the connect() method.
3. Creating a cursor object using the cursor() method.
4. Executing the query using the execute() method.
5. Retrieving the results using the fetchall() method.
6. Printing the results.

For more information, please refer to the MySQL Connector/Python documentation.

Edit this code on GitHub