mysqlclient_connect_execute_query_fetch_results.py

1import MySQLdb
2
3# Connect to the database
4# Replace 'host', 'user', 'passwd', and 'db' with your actual database credentials
5db = MySQLdb.connect(
6    host="localhost",
7    user="your_username",
8    passwd="your_password",
9    db="your_database"
10)
11
12# Create a cursor object using cursor() method
13cursor = db.cursor()
14
15# Execute a SQL query using execute() method
16cursor.execute("SELECT VERSION()")
17
18# Fetch a single row using fetchone() method
19data = cursor.fetchone()
20print("Database version : %s " % data)
21
22# Close the connection
23db.close()