Skip to content

Instantly share code, notes, and snippets.

@dharm6619

dharm6619/DbConn.py

Created October 15, 2019 07:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dharm6619/eb7115ca8e68057a061052c2b831b074 to your computer and use it in GitHub Desktop.
Save dharm6619/eb7115ca8e68057a061052c2b831b074 to your computer and use it in GitHub Desktop.
Download ZIP
For Database Connectivity
Raw
DbConn.py
import pymysql
connection = pymysql.connect("localhost","root","root","TEST")
print("Connected to Database")
cursor = connection.cursor()
sql = "insert into demo values(1,'Dharmendra',98)"
cursor.execute(sql)
print("Inserted")
connection.commit()
sql = "select * from TEST"
cursor.execute(sql)
cursor.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment