MYSQL INTERFACE
SELECTION USING PYTHON SQL
CONNECTOR-
import [Link] as sqlcon
mycon=[Link](host='localhost',user='root',passwd='
kashishmadan14',database='kashish')
if mycon.is_connected():
print('Sucessfully Connected to MYSQL Database')
mycursor=[Link]()
[Link]("select * from MEMBER")
for data in mycursor:
print(data)
INSERTION USING PYTHON SQL
CONNECTOR-
import [Link] as sqlconn2
myconn=[Link](host='localhost',user='root',passw
d='kashishmadan14',database='kashish')
if myconn.is_connected()==False:
print('Erro connecting to MySQL')
Name=input("Enter name");
Date=input('DOB');
type=input('type');
remarks=input('Enter remarks')
mycursor=[Link]()
[Link]("insert into SALESPERSON
values('"+str(Name)+"','"+Date+"','"+type+"','"+remarks+"')")
[Link]()
DELETION USING PYTHON SQL
CONNECTOR-
import [Link] as sqlcon
mycon=[Link](host='localhost',user='root
',passwd='kashishmadan14',database='kashish')
if mycon.is_connected():
print('Sucessfully Connected to MYSQL
Database')
mycursor=[Link]()
[Link]("drop SALESPERSON")
for data in mycursor:
print(data)
CREATION OF TABLE IN PYTHON SQL
CONNECTOR-
import [Link] as conn
mydb=[Link](host='localhost',user='root',passwd='kas
hishmadan14',database='kashish')
mycursor=[Link]()
[Link]('create table cust_data(cust_id integer
primary key, name varchar(25), gender varchar(1),DOB
date,Address varchar(20))');
[Link]()
