Python操作mysql数据库_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
# conn.commit()


6.删除数据 

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