Python for Beginners - Database Connectivity by using MySQL - Leela Soft - Ramavarapadu - Vijayawada
#LEELA SOFT #PYTHON #MYSQL #DATABASE #CONNECTIVITY
Steps to connect MySQL database by using Python
1.install required database library
2.import that module :
import pymysql
3.connection establish:
con = mysql.connect("","","","")
4.cursor object:
cur = con.cursor()
5.Execute SQL Queries by using cursor object
execute(sql_query) #single query
executescript(sql_queries) #
executemany(sql_queries) #parametarised
select * from ?
DDL:
create
alter
truncate
drop
DML:
insert
update
delete
6.commit or rollback:
commit()
rollback()
7.Select statment:
fetchone() #one record
fetchmany(n) #to fetch first n record
fetchall()