Advertisement
abobaker09

connect mysql 2 in python

Oct 9th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.21 KB | None | 0 0
  1. #connect data base
  2. import mysql.connector
  3. con=mysql.connector.connect (user="root",password="",host="localhost",database="beko")
  4. #defind cursor
  5. c=con.cursor()
  6.  #creat table
  7. #sq=' create table hilal (id int,name char(50),aded char(60),   sal int )'
  8. #insert values
  9. #sq="insert into hilal values ( 13,'ali','karthom',800)"
  10. #user insert values
  11. #iid=int (input ("enter id\n"))
  12. #name=str (input ("enter the name\n"))
  13. #adre=str (input ("enter adrees\n"))
  14. #salr=int (input ("enter salry\n"))
  15. #sq="insert into hilal values ('%d','%s','%s','%d')"% (iid,name,adre,salr)
  16. #use try with insert
  17. #because is procser insert
  18. #try:
  19.    # c.execute(sq)
  20.    #fun commit run insert
  21.     #con.commit()
  22.    # print ("hi")
  23. #use except proces error
  24. #except:
  25.     #fun rollback prosers error
  26.     #con.rollback()
  27. #sql="create table bekooo (code int not null ,name char(50),salry int)"
  28. #c.execute(sql)
  29. #sq="insert into bekooo values ('%d','%s','%d')"% (iid,name,salr)
  30. #use update and where data
  31. #sq="update bekooo set salry=38000 where code=2"
  32.  
  33. #try:
  34.    # c.execute(sq)
  35.    #fun commit run insert
  36.    # con.commit()
  37.    # print ("hi")
  38. #use except proces error
  39. #except:
  40.     #fun rollback prosers error
  41.    # con.rollback()
  42. con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement