python操作mysql

python操作mysql_python mysql-CSDN博客

import pymysql
 
# 连接MySQL，自动执行 use userdb; -- 进入数据库
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='root123', charset="utf8", db='userdb')
cursor = conn.cursor()
 
 
# 1.新增（需commit）
"""
cursor.execute("insert into tb1(name,password) values('李四','123123')")
conn.commit()
"""
 
# 2.删除（需commit）
"""
cursor.execute("delete from tb1 where id=1")
conn.commit()
"""
 
# 3.修改（需commit)
"""
cursor.execute("update tb1 set name='xx' where id=1")
conn.commit()
"""
 
# 4.查询
"""
cursor.execute("select * from tb where id>10")
data = cursor.fetchone() # cursor.fetchall()
print(data)
"""
 
# 关闭连接
cursor.close()
conn.close()