python and mysql connectivity

Razoltheren answered on May 16, 2020 Popularity 9/10 Helpfulness 1/10

answer python and mysql connectivity

python and mysql connectivity

Comment

-2

import pymysql

############### CONFIGURE THIS ###################
# Open database connection
db = pymysql.connect("database_host","username","password","database_name")
##################################################

# 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.
data = cursor.fetchone()
print ("Database version : {0}".format(data))

# disconnect from server
db.close()

Popularity 9/10 Helpfulness 1/10 Language sql

Source: copitosystem.com

Tags: python sql

Link to this answer
Share Copy Link

Contributed on May 16 2020

Razoltheren

0 Answers Avg Quality 2/10

python and mysql connectivity

Contents

More Related Answers

python and mysql connectivity

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.