python-mysql

import mysql.connector

db_config = {
    'host': 'xxxx',
    'user': 'xxx',
    'password': 'xxx',
    'port': '3306',
    'database': 'xxxx'
}

# 创建一个数据库连接
conn = mysql.connector.connect(**db_config)

# 游标cursor
cursor = conn.cursor()

# 写SQL语句
# query_sql = 'select * from member limit 1;'
query_sql = 'select MobilePhone from member limit 5;'

# 执行语句
cursor.execute(query_sql)

# 获取查询结果
# res = cursor.fetchone() # 元祖 针对一条数据
res = cursor.fetchall() # 列表 针对多条数据  列表嵌套元祖

print(res)

# 关闭游标
cursor.close()

#关闭连接
conn.close()