python对 MySQL 数据库进行增删改查的脚本

python对 MySQL 数据库进行增删改查的脚本

# -*- coding: utf-8 -*-
import pymysql
import xlrd
# import codecs
#连接数据库
conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", passwd="", db="test_hvr", charset="utf8")
cursor = conn.cursor()

# 查询数据库
effect_row = cursor.execute("select * from kkpb_account where user_name="18800000000"")
row_1 = cursor.fetchmany(10)
print(row_1)
for row in row_1:
  with open("ha.xls","a")as f:
    f.write(str(row[0]))
#   print(row[0])

# 使用预处理语句创建表
# sql = """CREATE TABLE EMPLOYEE (
#     FIRST_NAME CHAR(20) NOT NULL,
#     LAST_NAME CHAR(20),
#     AGE INT,
#     SEX CHAR(1),
#     INCOME FLOAT )"""
# cursor.execute(sql)

# 数据库插入数据
# s_id="25"
# name="aaa"
# price="154.21"
# sql="insert into stu (id) VALUES ("%s")"%(s_id,)
# add_row=cursor.execute(sql)

# 删除数据
# name="asds"
# sql="delete from user where name = "%s"" % name
# dele_row=cursor.execute(sql)

# 更新数据
# userid="10"
# sql="update user set price=124.21 where userid="%s""%userid
# upd_row=cursor.execute(sql)

conn.commit()
cursor.close()
conn.close()

以上就是python对 MySQL 数据库进行增删改查的脚本的详细内容,更多关于python 操作MySQL数据库的资料请关注云海天教程其它相关文章!

原文链接:https://www.cnblogs.com/carey9420/p/12180640.html