# -*- coding: utf-8 -*-import pymysqlimport 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()