Python操作mysql数据库

1. python连接数据库

import pymysql

# 连接数据库
conn = pymysql.connect(host="127.0.0.1",port=3306,user="root",password="123456",database="courier",charset="utf8");

2. 创建游标

# 创建游标对象，他是一个可以执行SQL语句的光标对象
cursor = conn.cursor()

3. 增加一条新的数据。

# 插入sql操作
sql = "insert into manage(name,address)values (%(name)s,%(address)s)"
cursor.execute(sql,{"name":"lalala","address":"caiji"});
conn.commit()
cursor.close()

4. 查询表的所有数据和根据条件查询

# 查询所有数据库信息
# sql = "select * from manage "
# cursor.execute(sql)
# students = cursor.fetchall()
# # print(student)
# for student in students:
#     # print(student)
#     print(student[1])

# 条件查询
# sql = "select * from manage where name='李慧慷'"
# cursor.execute(sql)
# student = cursor.fetchall()
# print(student)

5. 更新数据

# 更新操作
# sql = "update manage set address=%s where name=%s"
# cursor.execute(sql,("中北大学软件学院","李慧慷"))
# conn.commit()

6. 删除数据

# 删除操作
sql = "delete  from manage where name = %s"
cursor.execute(sql,("lalala"))
conn.commit()