Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #connect data base
- import mysql.connector
- con=mysql.connector.connect (user="root",password="",host="localhost",database="beko")
- #defind cursor
- c=con.cursor()
- #creat table
- #sq=' create table hilal (id int,name char(50),aded char(60), sal int )'
- #insert values
- #sq="insert into hilal values ( 13,'ali','karthom',800)"
- #user insert values
- #iid=int (input ("enter id\n"))
- #name=str (input ("enter the name\n"))
- #adre=str (input ("enter adrees\n"))
- #salr=int (input ("enter salry\n"))
- #sq="insert into hilal values ('%d','%s','%s','%d')"% (iid,name,adre,salr)
- #use try with insert
- #because is procser insert
- #try:
- # c.execute(sq)
- #fun commit run insert
- #con.commit()
- # print ("hi")
- #use except proces error
- #except:
- #fun rollback prosers error
- #con.rollback()
- #sql="create table bekooo (code int not null ,name char(50),salry int)"
- #c.execute(sql)
- #sq="insert into bekooo values ('%d','%s','%d')"% (iid,name,salr)
- #use update and where data
- #sq="update bekooo set salry=38000 where code=2"
- #try:
- # c.execute(sq)
- #fun commit run insert
- # con.commit()
- # print ("hi")
- #use except proces error
- #except:
- #fun rollback prosers error
- # con.rollback()
- con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement