Skip to main content

GRADE XII - MYSQL CONNECTIVITY WITH PYTHON

 GRADE XII - MYSQL CONNECTIVITY WITH PYTHON


SOURCE CODE :

#ADD TO DATABASE

import mysql.connector

mydb = mysql.connector.connect(

host="localhost",

user="root",

passwd="root",

database="school" )

mycursor=mydb.cursor()

v1=input("enter GROCERY ID:")

v2=input("enter GROCERY NAME:")

v3=int(input("enter PRICE:"))

v4=int(input("enter QUANTITY:"))

sql='insert into GRO values("%s","%s","%d","%d")'%(v1,v2,v3,v4)

 #print(sql)

mycursor.execute(sql)

mydb.commit()

print("*********Grocery Added To Database Successfully*****")


#TO VIEW DATA

sql="select * from gro"

mycursor.execute(sql)

res=mycursor.fetchall()

print("The AVAILABLE GROCERY details are as follows : ")

print("G_ID    NAME     PRICE   QUANTITY")

print("\n##*************************************** ************ ##")

for x in res:

        print(x)

print("\n##***************************************************  ##")

Comments

Post a Comment

Popular posts from this blog

GRADE XII - Python Connectivity with MySQL

  Python Connectivity with MySQL In real-life applications, the data inputted by the user and processed by the application needs to be saved permanently, so that it can be used for future manipulation. Usually, input and output data is displayed during execution but not stored, as it resides in main memory , which is temporary — i.e., it gets erased once the application is closed. This limitation can be overcome by sending the data to be stored in a database , which is made accessible to the user through a Front-End interface . Key Concepts Database A database is an organized collection of data that is stored and accessed electronically from a computer system. DBMS (Database Management System) A DBMS is software that interacts with end-users, applications, and the database to capture and analyze data. Front-End The Front-End is the user interface of the application, responsible for input/output interaction with the user. Back-End The Back-End refe...
Post a Comment
Read more

GRADE XII - CSV FILE

CSV FILE (COMMA SEPERATED VALUE) CSV NOTES LINK :  CSV NOTES - CLICK HERE Writing data to a CSV file involves the following steps: Import the csv module Open the CSV file in write mode ( "w" ) using open() Create the writer object Write the data into the file using the writer object Close the file using close() writerow() Method This method is used to write a single row to a CSV file. It takes a sequence (list or tuple) as its parameter, and writes the items as a comma-separated line in the file. You do not need to add a newline character (\n) — it automatically places the end-of-line marker.     EXAMPLE 1: import csv  # Importing the csv module # CSV file opened using relative path csv_fobj = open("emp.csv", "w")   # Writer object created wtr_obj = csv.writer(csv_fobj) # Record with field heading is written wtr_obj.writerow(["Empno", "Name", "Salary"]) # Records with data are...
Post a Comment
Read more