Python 使用pymysql操作MySQL

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='123456', charset='utf8', db='表名')
# 加pymysql.cursors.DictCursor可以使返回值变成字典，不加返回值是元组
cursor = conn.cursor(pymysql.cursors.DictCursor)

# 增加数据
cursor.execute('insert into admin(user_name, password, mobile) values(\'张三\', \'123456\', \'13812345678\')')
conn.commit()

# 拼接传入方式一
sql = 'insert into admin(user_name, password, mobile) values(%s, %s, %s)'
cursor.execute(sql, ['李四', '654321', '13512345678'])
conn.commit()

# 拼接传入方式二
sql = 'insert into admin(user_name, password, mobile) values(%(n1)s, %(n2)s, %(n3)s)'
cursor.execute(sql, {'n1': '王五', 'n2': '7654321', 'n3': '13912345678'})
conn.commit()

# 查询数据
sql = 'select * from admin'
cursor.execute(sql)
# 获取一条数据
data_list = cursor.fetchone()
print(data_list)
# 获取全部数据
data_list = cursor.fetchall()
print(data_list)

# 关闭连接
cursor.close()
conn.close()