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数据库的资料请关注我们其它相关文章!
赞 (0)