Python Database Connectivity

Steps to conect python to mysql databaseStep 1:
import pymysql
Step 2:
Open database connection
Step 3:
prepare a cursor object using cursor() method
Step 4:
execute SQL query using execute() method.
Step 5:
Fetch a single row using fetchone() method.
Step 6:
disconnect from server

How To Connect The MYSQL Database

#!C:\Users\Varshini\AppData\Local\Programs\Python\Python37-32

import pymysql# Open database connectiondb = pymysql.connect(host="localhost",user="root",password = "",db="Rain",)# prepare a cursor object using cursor() method
cursor = db.cursor()# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()")# Fetch a single row using fetchone() method.
output = cursor.fetchone()
print ("Database version : %s " % output)# disconnect from server
db.close()




Continue Reading....