python操作mysql基础用法

# pip install pymysql

from itertools import chain
import pymysql

host = "127.0.0.1"
port = 3306
user = "username"
password = "password"
db_name = "database"


"""操作Mysql数据库"""
db = pymysql.connect(host=host, port=int(port),
                     user=user, passwd=password,
                     db=db_name)
cursor = db.cursor()  # 获取操作游标
# 获取组-id
cursor.execute("select id from apptest_appcasestep")
casestep_id = cursor.fetchall()
casestep_id = list(chain.from_iterable(casestep_id))  # 定位方式  二维元组转换为一维列表
db.commit()
cursor.close()  # 关闭游标
db.close()  # 关闭数据库