Bank Management- Python Project for class 12 MySQL Connectivity
Bank Management- Python Project Class 12 Source Code: #https://cbsepython.in print(“****BANK TRANSACTION****”) #creating database import mysql.connector mydb=mysql.connector.connect (host=”localhost”,user=”root”, passwd=”admin”) mycursor=mydb.cursor() mycursor.execute(“create database if not exists bank”) mycursor.execute(“use bank”) #creating required tables mycursor.execute(“create table if not exists bank_master(acno char(4) primary key,name varchar(30),city char(20),mobileno char(10),balance int(6))”) mycursor.execute(“create table if not exists banktrans(acno char (4),amount int(6),dot date,ttype char(1),foreign … Read more