数据的增删改查

导入模块

import pymysql

 

conn = pymysql.connect(

user = "root",

db = "day36",

host = "127.0.0.1",

post = 3306,

charset = "utf8"

autocommit = True  #自动提交确认

)

cursor = conn.cursor(cursor = pymysql.cursors.DictCursor)

#以字典形式输出出来

#获取用户输入的用户名和密码，然后取数据库中校验

username = input("usename>>:").strip()

password = input("password>>:").strip()

sql = select * from userinfo where name = %s and password = %s"

print(sql)

增

sql = "insert into userinfo(name,password,dep_id) values ("jason",789,1)"

改

sql = "update userinfo set name = "egons" where id = 6"

删除

sql = "delete from userinfo where id = 1"

res = cursor.execute(sql)

conn.commit()   #确认当前操作，真正的同步到数据库

如果真想操作，必须有一步确认操作。