# -*- coding: utf-8 -*-import pymysqlimport xlrd# import codecs#連接數(shù)據(jù)庫conn = pymysql.connect(host=’127.0.0.1’, port=3306, user=’root’, passwd=’’, db=’test_hvr’, charset=’utf8’)cursor = conn.cursor()# 查詢數(shù)據(jù)庫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])# 使用預處理語句創(chuàng)建表# sql = '''CREATE TABLE EMPLOYEE (# FIRST_NAME CHAR(20) NOT NULL,# LAST_NAME CHAR(20),# AGE INT,# SEX CHAR(1),# INCOME FLOAT )'''# cursor.execute(sql)# 數(shù)據(jù)庫插入數(shù)據(jù)# s_id=’25’# name=’aaa’# price=’154.21’# sql='insert into stu (id) VALUES (’%s’)'%(s_id,)# add_row=cursor.execute(sql)# 刪除數(shù)據(jù)# name=’asds’# sql='delete from user where name = ’%s’' % name# dele_row=cursor.execute(sql)# 更新數(shù)據(jù)# 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 數(shù)據(jù)庫進行增刪改查的腳本的詳細內(nèi)容，更多關于python 操作MySQL數(shù)據(jù)庫的資料請關注好吧啦網(wǎng)其它相關文章！