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数据库的资料请关注免费资源网其它相关文章！